index

Package tb_misc_detail

The Common Business interface for the Miscellaneous Receipt Detail API (MISC_DETAIL).
 
A miscellaneous transaction is identified as money being received that is not posted to the receivable account of a specific person, non-person, or grant account.
 
All parameters are case sensitive; they are validated as provided.
User validation exits are provided for functions CREATE and UPDATE.

Program units
f_api_version   Returns the API version number.
f_exists   Checks to see if a record exists.
f_isequal   Compare two records for equality.
f_max_tran_number   Returns maximum transaction number for receipt.
f_query_all   Selects all records for the entity.
f_query_by_rowid   Selects one record using rowid.
f_query_cashier   Select all records for a cashiering session.
f_query_one   Selects one record using key.
f_query_one_lock   Selects one record and locks it.
f_total_by_dr_cr   Total of Debit or Credit detail for a miscellaneous receipt.
p_create   Creates a record.
p_lock   Locks a record.
p_update   Updates a record.

Types
misc_detail_rec   Entity record type
misc_detail_ref   Entity cursor variable type
misc_detail_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity name

M_ENTITY_NAME 

M_ENTITY_NAME    CONSTANT VARCHAR2(11) := 'MISC_DETAIL';

Business Entity name

misc_detail_rec 

TYPE misc_detail_rec IS RECORD (
   r_pay_detail_code         tbrmisd.tbrmisd_pay_detail_code%TYPE,
   r_charge_detail_code      tbrmisd.tbrmisd_charge_detail_code%TYPE,
   r_amount                  tbrmisd.tbrmisd_amount%TYPE,
   r_desc                    tbrmisd.tbrmisd_desc%TYPE,
   r_receipt_number          tbrmisd.tbrmisd_receipt_number%TYPE,
   r_user                    tbrmisd.tbrmisd_user%TYPE,
   r_tran_number             tbrmisd.tbrmisd_tran_number%TYPE,
   r_acct_feed_ind           tbrmisd.tbrmisd_acct_feed_ind%TYPE,
   r_charge_coas             tbrmisd.tbrmisd_charge_coas%TYPE,
   r_charge_acci             tbrmisd.tbrmisd_charge_acci%TYPE,
   r_charge_fund             tbrmisd.tbrmisd_charge_fund%TYPE,
   r_charge_orgn             tbrmisd.tbrmisd_charge_orgn%TYPE,
   r_charge_acct             tbrmisd.tbrmisd_charge_acct%TYPE,
   r_charge_prog             tbrmisd.tbrmisd_charge_prog%TYPE,
   r_charge_actv             tbrmisd.tbrmisd_charge_actv%TYPE,
   r_charge_locn             tbrmisd.tbrmisd_charge_locn%TYPE,
   r_pay_coas                tbrmisd.tbrmisd_pay_coas%TYPE,
   r_pay_acci                tbrmisd.tbrmisd_pay_acci%TYPE,
   r_pay_fund                tbrmisd.tbrmisd_pay_fund%TYPE,
   r_pay_orgn                tbrmisd.tbrmisd_pay_orgn%TYPE,
   r_pay_acct                tbrmisd.tbrmisd_pay_acct%TYPE,
   r_pay_prog                tbrmisd.tbrmisd_pay_prog%TYPE,
   r_pay_actv                tbrmisd.tbrmisd_pay_actv%TYPE,
   r_pay_locn                tbrmisd.tbrmisd_pay_locn%TYPE,
   r_session_number          tbrmisd.tbrmisd_session_number%TYPE,
   r_cshr_end_date           tbrmisd.tbrmisd_cshr_end_date%TYPE,
   r_charge_account          tbrmisd.tbrmisd_charge_account%TYPE,
   r_pay_account             tbrmisd.tbrmisd_pay_account%TYPE,
   r_pay_rucl_code           tbrmisd.tbrmisd_pay_rucl_code%TYPE,
   r_charge_rucl_code        tbrmisd.tbrmisd_charge_rucl_code%TYPE,
   r_trans_date              tbrmisd.tbrmisd_trans_date%TYPE,
   r_document_number         tbrmisd.tbrmisd_document_number%TYPE,
   r_dr_cr_ind               tbrmisd.tbrmisd_dr_cr_ind%TYPE,
   r_curr_code               tbrmisd.tbrmisd_curr_code%TYPE,
   r_foreign_amount          tbrmisd.tbrmisd_foreign_amount%TYPE,
   r_feed_date               tbrmisd.tbrmisd_feed_date%TYPE,
   r_feed_doc_code           tbrmisd.tbrmisd_feed_doc_code%TYPE,
   r_pidm                    tbrmisd.tbrmisd_pidm%TYPE,
   r_ccrd_code               tbrmisd.tbrmisd_ccrd_code%TYPE,
   r_card_exp_date           tbrmisd.tbrmisd_card_exp_date%TYPE,
   r_payment_id              tbrmisd.tbrmisd_payment_id%TYPE,
   r_card_auth_number        tbrmisd.tbrmisd_card_auth_number%TYPE,
   r_merchant_id             tbrmisd.tbrmisd_merchant_id%TYPE,
   r_data_origin             tbrmisd.tbrmisd_data_origin%TYPE,
   r_create_source           tbrmisd.tbrmisd_create_source%TYPE,
   r_internal_record_id      gb_common.internal_record_id_type);

Entity record type

misc_detail_ref 

TYPE misc_detail_ref IS REF CURSOR RETURN misc_detail_rec;

Entity cursor variable type

misc_detail_tab 

TYPE misc_detail_tab IS TABLE OF misc_detail_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version 

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns
Version of the API signature. Changes only when the signature changes.

f_exists 

Function f_exists(p_user           tbrmisd.tbrmisd_user%TYPE,
                  p_tran_number    tbrmisd.tbrmisd_tran_number%TYPE,
                  p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE,
                  p_rowid          VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Checks to see if a record exists.

Parameters
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key
p_rowid   Database rowid of record to select. VARCHAR2(18)

Returns
Y if found, otherwise N.

f_isequal 

Function f_isequal(rec_one misc_detail_rec, rec_two misc_detail_rec)
  RETURN VARCHAR2

Compare two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.
* @param rec_one The first record to compare. Type misc_detail_rec Required
* @param rec_two The second record to compare. Type misc_detail_rec Required
* @return Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_max_tran_number 

Function f_max_tran_number(p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE)
  RETURN NUMBER

Returns maximum transaction number for receipt.

Parameters
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Required Key

Returns
Maximum transaction number that exists for this receipt number.

f_query_all 

Function f_query_all(p_user            tbrmisd.tbrmisd_user%TYPE DEFAULT NULL,
                     p_tran_number     tbrmisd.tbrmisd_tran_number%TYPE DEFAULT NULL,
                     p_receipt_number  tbrmisd.tbrmisd_receipt_number%TYPE DEFAULT NULL,
                     p_document_number tbrmisd.tbrmisd_document_number%TYPE DEFAULT NULL)
  RETURN misc_detail_ref

Selects all records for the entity.
Parameters default to NULL and are ignored if not populated.
AND is used when multiple criteria are given.

Parameters
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key
p_document_number   Document number that references a source document for the miscellaneous transaction. VARCHAR2(8)

Returns
A cursor variable that will fetch the set of records.

f_query_by_rowid 

Function f_query_by_rowid(p_rowid VARCHAR2) RETURN misc_detail_ref

Selects one record using rowid.

Parameters
p_rowid   Database rowid of record to select. VARCHAR2(18) Required

Returns
A cursor variable that will fetch exactly one record.

f_query_cashier 

Function f_query_cashier(p_user           tbrmisd.tbrmisd_user%TYPE,
                         p_session_number tbrmisd.tbrmisd_session_number%TYPE,
                         p_cshr_end_date  tbrmisd.tbrmisd_cshr_end_date%TYPE DEFAULT NULL)
  RETURN misc_detail_ref

Select all records for a cashiering session.

Parameters
p_user   User ID of the cashier of the session. VARCHAR2(30) Required
p_session_number   Cashier session number (0 = current session). NUMBER(5) Required
p_cshr_end_date   End date and time of the cashiering session. DATE

Returns
A cursor variable that will fetch the set of records by cashier session.

f_query_one 

Function f_query_one(p_user           tbrmisd.tbrmisd_user%TYPE,
                     p_tran_number    tbrmisd.tbrmisd_tran_number%TYPE,
                     p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE)
  RETURN misc_detail_ref

Selects one record using key.

Parameters
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

Function f_query_one_lock(p_user           tbrmisd.tbrmisd_user%TYPE,
                          p_tran_number    tbrmisd.tbrmisd_tran_number%TYPE,
                          p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE,
                          p_rowid          VARCHAR2 DEFAULT NULL)
  RETURN misc_detail_ref

Selects one record and locks it.

Parameters
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key
p_rowid   Database rowid of record to select. VARCHAR2(18)

Returns
A cursor variable for one record, locking the record.

f_total_by_dr_cr 

Function f_total_by_dr_cr(p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE,
                          p_dr_cr_ind      tbrmisd.tbrmisd_dr_cr_ind%TYPE)
  RETURN NUMBER

Total of Debit or Credit detail for a miscellaneous receipt.

Parameters
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Required Key
p_dr_cr_ind   The Debit Credit Indicator identifies this transaction as a debit (D) or credit (C) to the finance ledger. VARCHAR2(1) Required

Returns
Total amount of the Debits or Credits for a miscellaneous receipt.

p_create 

Procedure p_create(p_pay_detail_code    tbrmisd.tbrmisd_pay_detail_code%TYPE DEFAULT NULL,
                   p_charge_detail_code tbrmisd.tbrmisd_charge_detail_code%TYPE DEFAULT NULL,
                   p_amount             tbrmisd.tbrmisd_amount%TYPE DEFAULT NULL,
                   p_desc               tbrmisd.tbrmisd_desc%TYPE DEFAULT NULL,
                   p_receipt_number     tbrmisd.tbrmisd_receipt_number%TYPE,
                   p_user               tbrmisd.tbrmisd_user%TYPE,
                   p_acct_feed_ind      tbrmisd.tbrmisd_acct_feed_ind%TYPE DEFAULT 'Y',
                   p_charge_coas        tbrmisd.tbrmisd_charge_coas%TYPE DEFAULT NULL,
                   p_charge_acci        tbrmisd.tbrmisd_charge_acci%TYPE DEFAULT NULL,
                   p_charge_fund        tbrmisd.tbrmisd_charge_fund%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_charge_orgn        tbrmisd.tbrmisd_charge_orgn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_charge_acct        tbrmisd.tbrmisd_charge_acct%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_charge_prog        tbrmisd.tbrmisd_charge_prog%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_charge_actv        tbrmisd.tbrmisd_charge_actv%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_charge_locn        tbrmisd.tbrmisd_charge_locn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_coas           tbrmisd.tbrmisd_pay_coas%TYPE DEFAULT NULL,
                   p_pay_acci           tbrmisd.tbrmisd_pay_acci%TYPE DEFAULT NULL,
                   p_pay_fund           tbrmisd.tbrmisd_pay_fund%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_orgn           tbrmisd.tbrmisd_pay_orgn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_acct           tbrmisd.tbrmisd_pay_acct%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_prog           tbrmisd.tbrmisd_pay_prog%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_actv           tbrmisd.tbrmisd_pay_actv%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pay_locn           tbrmisd.tbrmisd_pay_locn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_session_number     tbrmisd.tbrmisd_session_number%TYPE DEFAULT 0,
                   p_cshr_end_date      tbrmisd.tbrmisd_cshr_end_date%TYPE DEFAULT NULL,
                   p_charge_account     tbrmisd.tbrmisd_charge_account%TYPE DEFAULT NULL,
                   p_pay_account        tbrmisd.tbrmisd_pay_account%TYPE DEFAULT NULL,
                   p_pay_rucl_code      tbrmisd.tbrmisd_pay_rucl_code%TYPE DEFAULT NULL,
                   p_charge_rucl_code   tbrmisd.tbrmisd_charge_rucl_code%TYPE DEFAULT NULL,
                   p_trans_date         tbrmisd.tbrmisd_trans_date%TYPE DEFAULT NULL,
                   p_document_number    tbrmisd.tbrmisd_document_number%TYPE DEFAULT NULL,
                   p_dr_cr_ind          tbrmisd.tbrmisd_dr_cr_ind%TYPE DEFAULT NULL,
                   p_curr_code          tbrmisd.tbrmisd_curr_code%TYPE DEFAULT NULL,
                   p_foreign_amount     tbrmisd.tbrmisd_foreign_amount%TYPE DEFAULT NULL,
                   p_pidm               tbrmisd.tbrmisd_pidm%TYPE DEFAULT NULL,
                   p_ccrd_code          tbrmisd.tbrmisd_ccrd_code%TYPE DEFAULT NULL,
                   p_card_exp_date      tbrmisd.tbrmisd_card_exp_date%TYPE DEFAULT NULL,
                   p_payment_id         tbrmisd.tbrmisd_payment_id%TYPE DEFAULT NULL,
                   p_card_auth_number   tbrmisd.tbrmisd_card_auth_number%TYPE DEFAULT NULL,
                   p_merchant_id        tbrmisd.tbrmisd_merchant_id%TYPE DEFAULT NULL,
                   p_data_origin        tbrmisd.tbrmisd_data_origin%TYPE DEFAULT NULL,
                   p_tran_number_out    OUT tbrmisd.tbrmisd_tran_number%TYPE,
                   p_rowid_out          OUT VARCHAR2)

Creates a record.
Required fields are User ID (cashier), Receipt Number, and either Charge Detail Code or Pay Detail Code.
   If Rule Class Security is on, User ID must have permission to use the Rule Class Code with form TFAMISC.
 
Amount is required except where it may be calculated using Currency Code and Foreign Amount.
   If this data pair and Amount are both populated, then the calculation must yield the Amount provided.
 
The Transaction Number is determined by the API and returned as an OUT parameter.
Description will default from the Detail Code if not provided.
Accounting Feed will default to Y.
Session Number will default to 0 (current session). Any other value requires Cashier End Date, and the combination must be valid in the Cashier Session table (TBBCSHR).
Currency Code and Foreign Amount are both null or both provided.
Credit Card data should be pre-validated.
A Document Number may only be used in association with one Miscellaneous Receipt Number, and the same Document should be recorded on the header and all detail records.
 
When Ledger Numbers are enterable -
   No defaulting of accounting values will occur for parameters which are specified, including NULL.
   Defaulting will occur following standard Finance rules for parameters not specified or populated with dml_common.f_unspecified_string.
 
Other optional parameters may also have editing to enforce Miscellaneous Receivable business rules.

Parameters
p_pay_detail_code   Payment detail code associated with the debit side of a miscellaneous transaction. Required when Debit Credit Indicator is set to D, valid in TBBDETC. VARCHAR2(4)
p_charge_detail_code   Charge detail code associated with the credit side of a miscellaneous transaction. Required when Debit Credit Indicator is set to C, valid in TBBDETC. VARCHAR2(4)
p_amount   The amount of the miscellaneous transaction. NUMBER(12,2)
p_desc   Free-Form description associated with the miscellaneous transaction.  Default value comes from the Detail Code description (TBBDESC). VARCHAR2(30)
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key Required Key
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_acct_feed_ind   Accounting Feed indicator. VARCHAR2(1)
Y   Feed transaction (default)
F   Transaction fed

p_charge_coas   Banner Finance Chart Of Accounts Code for the credit side of a miscellaneous transaction, valid in FTVCOAS. VARCHAR2(1)
p_charge_acci   Banner Finance Index Code for the credit side of a miscellaneous transaction, valid in FTVACCI. VARCHAR2(6)
p_charge_fund   Banner Finance Fund Code for the credit side of a miscellaneous transaction, valid in FTVFUND. VARCHAR2(6)
p_charge_orgn   Banner Finance Organization Code for the credit side of a miscellaneous transaction, valid in FTVORGN. VARCHAR2(6)
p_charge_acct   Banner Finance Account Code for the credit side of a miscellaneous transaction, valid in FTVACCT. VARCHAR2(6)
p_charge_prog   Banner Finance Program Code for the credit side of a miscellaneous transaction, valid in FTVPROG. VARCHAR2(6)
p_charge_actv   Banner Finance Activity Code for the credit side of a miscellaneous transaction, valid in FTVACTV. VARCHAR2(6)
p_charge_locn   Banner Finance Location Code for the credit side of a miscellaneous transaction, valid in FTVLOCN. VARCHAR2(6)
p_pay_coas   Banner Finance Chart Of Accounts Code for the debit side of a miscellaneous transaction, valid in FTVCOAS. VARCHAR2(1)
p_pay_acci   Banner Finance Index Code for the debit side of a miscellaneous transaction, valid in FTVACCI. VARCHAR2(6)
p_pay_fund   Banner Finance Fund Code for the debit side of a miscellaneous transaction, valid in FTVFUND. VARCHAR2(6)
p_pay_orgn   Banner Finance Organization Code for the debit side of a miscellaneous transaction, valid in FTVORGN. VARCHAR2(6)
p_pay_acct   Banner Finance Account Code for the debit side of a miscellaneous transaction, valid in FTVACCT. VARCHAR2(6)
p_pay_prog   Banner Finance Program Code for the debit side of a miscellaneous transaction, valid in FTVPROG. VARCHAR2(6)
p_pay_actv   Banner Finance Activity Code for the debit side of a miscellaneous transaction, valid in FTVACTV. VARCHAR2(6)
p_pay_locn   Banner Finance Location Code for the debit side of a miscellaneous transaction, valid in FTVLOCN. VARCHAR2(6)
p_session_number   Cashier session number in which this transaction was posted (0 = current session). NUMBER(5)
p_cshr_end_date   End date and time of the cashiering session for this transaction. DATE
p_charge_account   Free-Form account number for the credit side of a miscellaneous transaction; used when Banner Finance is not installed. VARCHAR2(60)
p_pay_account   Free-Form account number for the debit side of a miscellaneous transaction; used when Banner Finance is not installed. VARCHAR2(60)
p_pay_rucl_code   Rule class code for the debit side of a miscellaneous transaction; used when the transaction is fed to the finance system, valid in FTVRUCL with class type J. VARCHAR2(4)
p_charge_rucl_code   Rule class code for the credit side of a miscellaneous transaction; used when the transaction is fed to the finance system, valid in FTVRUCL with class type J. VARCHAR2(4)
p_trans_date   Transaction date used by the finance system to control posting to the ledgers. DATE
p_document_number   Document number that references a source document for the miscellaneous transaction. VARCHAR2(8)
p_dr_cr_ind   The Debit Credit Indicator for the transaction in the finance ledger. VARCHAR2(1)
D   Debit
C   Credit

p_curr_code   Foreign currency code used when creating the payment side of a miscellaneous transaction. VARCHAR2(4)
p_foreign_amount   The amount of the transaction stated in foreign currency. NUMBER(12,2)
p_pidm   Optional internal identification number, allows association of miscellaneous transactions with an existing entity, valid in SPRIDEN. NUMBER(8)
p_ccrd_code   Code identifying Credit Card Type used in authorizations via gateway, valid in GTVCCRD. VARCHAR2(10)
p_card_exp_date   Credit card expiration date supplied at time of credit card payment. DATE
p_payment_id   Free-Form information identifying a payment; often used to record check or credit card number. VARCHAR2(20)
p_card_auth_number   Credit Card Authorization Number received when transaction was processed. VARCHAR2(12)
p_merchant_id   Merchant ID associated with the Process Name Code, Credit Card Type Code, and System Code.  The Merchant ID is included in the credit card payment request transmitted to the vendor handling credit card payments. VARCHAR2(20)
p_data_origin   Source system that last created or updated the data. VARCHAR2(30)
p_tran_number_out   Returns transaction number assigned to the miscellaneous transaction. NUMBER(8) Required
p_rowid_out   Database rowid of record created. VARCHAR2(18) Required

p_lock 

Procedure p_lock(p_user           tbrmisd.tbrmisd_user%TYPE,
                 p_tran_number    tbrmisd.tbrmisd_tran_number%TYPE,
                 p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE,
                 p_rowid_inout    IN OUT VARCHAR2)

Locks a record.
If rowid is not passed in, the record is located using the key values and the rowid of the locked row is passed in p_rowid_inout.

Parameters
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Key
p_rowid_inout   Database rowid of record to lock. VARCHAR2(18) Required

p_update 

Procedure p_update(p_desc           tbrmisd.tbrmisd_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_receipt_number tbrmisd.tbrmisd_receipt_number%TYPE,
                   p_user           tbrmisd.tbrmisd_user%TYPE,
                   p_tran_number    tbrmisd.tbrmisd_tran_number%TYPE,
                   p_acct_feed_ind  tbrmisd.tbrmisd_acct_feed_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_session_number tbrmisd.tbrmisd_session_number%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_cshr_end_date  tbrmisd.tbrmisd_cshr_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_feed_date      tbrmisd.tbrmisd_feed_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_feed_doc_code  tbrmisd.tbrmisd_feed_doc_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_payment_id     tbrmisd.tbrmisd_payment_id%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin    tbrmisd.tbrmisd_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rowid          VARCHAR2 DEFAULT NULL)

Updates a record.
User ID Receipt and Transaction Number, or ROWID required.
Most updates to the record will be made by system processes.

Parameters
p_desc   Free-Form description associated with the miscellaneous transaction.  Default value comes from the Detail Code description (TBBDESC). VARCHAR2(30)
p_receipt_number   Receipt number assigned to the miscellaneous transaction. NUMBER(8) Required Key
p_user   User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required Key
p_tran_number   One-Up transaction number for each row of detail associated with a miscellaneous transaction receipt number. NUMBER(8) Required Key
p_acct_feed_ind   Accounting Feed indicator. VARCHAR2(1)
Y   Feed transaction
F   Transaction fed

p_session_number   Cashier session number in which this transaction was posted (0 = current session). NUMBER(5)
p_cshr_end_date   End date and time of the cashiering session for this transaction. DATE
p_feed_date   Date this transaction was fed to the finance system. DATE
p_feed_doc_code   Document code used to feed this transaction to the finance system. VARCHAR2(8)
p_payment_id   Free-Form information identifying a payment; often used to record check or credit card number. VARCHAR2(20)
p_data_origin   Source system that last created or updated the data. VARCHAR2(30)
p_rowid   Database rowid of record to update. VARCHAR2(18)