105: -- First Define the AssignRecType and AssignTabTyp
106:
107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
106:
107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,
117: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,
117: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE ,
118: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE ,
119: acctd_amount_due_remaining AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE ,
131: trx_type_type RA_CUST_TRX_TYPES.type%TYPE ,
132: receipt_method_name AR_RECEIPT_METHODS.NAME%TYPE ,
133: receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE ,
134: location HZ_CUST_SITE_USES.location%type ,
135: bill_to_site_use_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE ,
136: bank_name ce_bank_branches_v.bank_name%TYPE ,
137: bank_branch_id ce_bank_branches_v.branch_party_id%TYPE ,
138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
137: bank_branch_id ce_bank_branches_v.branch_party_id%TYPE ,
138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;
148:
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;
148:
149: