DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on RA_CUSTOMER_TRX

Line 773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
775: p_called_from IN VARCHAR2 DEFAULT NULL,
776: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
777: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 967: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

963: l_credit_rules VARCHAR2(30);
964:
965: l_x_status_meaning VARCHAR2(60);
966: l_x_reason_meaning VARCHAR2(60);
967: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
968: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:
969: l_x_line_amount RA_CM_REQUESTS.line_amount%TYPE;
970: l_x_tax_amount RA_CM_REQUESTS.tax_amount%TYPE;
971: l_x_freight_amount RA_CM_REQUESTS.freight_amount%TYPE;

Line 968: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:

964:
965: l_x_status_meaning VARCHAR2(60);
966: l_x_reason_meaning VARCHAR2(60);
967: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
968: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:
969: l_x_line_amount RA_CM_REQUESTS.line_amount%TYPE;
970: l_x_tax_amount RA_CM_REQUESTS.tax_amount%TYPE;
971: l_x_freight_amount RA_CM_REQUESTS.freight_amount%TYPE;
972: l_x_line_credits_flag VARCHAR2(1);

Line 2272: FROM ra_customer_trx_lines

2268: AND rec.secondary_application_ref_id = cv_root_claim_id;
2269:
2270: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
2271: SELECT customer_trx_id
2272: FROM ra_customer_trx_lines
2273: WHERE customer_trx_line_id = cv_invoice_line_id;
2274:
2275: BEGIN
2276: -------------------- initialize -----------------------

Line 2908: FROM ra_customer_trx_lines

2904: AND rec.secondary_application_ref_id = cv_root_claim_id;
2905:
2906: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
2907: SELECT customer_trx_id
2908: FROM ra_customer_trx_lines
2909: WHERE customer_trx_line_id = cv_invoice_line_id;
2910:
2911: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
2912: SELECT source_object_id, sum(claim_currency_amount) amt

Line 3163: FROM ra_customer_trx

3159:
3160: --4684931
3161: CURSOR csr_trx_currency(cv_customer_trx_id IN NUMBER) IS
3162: SELECT invoice_currency_code
3163: FROM ra_customer_trx
3164: WHERE customer_trx_id = cv_customer_trx_id;
3165:
3166: CURSOR csr_rec_currency(cv_cash_receipt_id IN NUMBER) IS
3167: SELECT currency_code

Line 3965: FROM ra_customer_trx

3961: AND secondary_application_ref_id = cv_root_claim_id;
3962:
3963: CURSOR csr_payment_trx_number(cv_customer_trx_id IN NUMBER) IS
3964: SELECT trx_number
3965: FROM ra_customer_trx
3966: WHERE customer_trx_id = cv_customer_trx_id;
3967:
3968: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
3969: SELECT amount_applied,

Line 3992: FROM ra_customer_trx

3988:
3989: --bug 4684931
3990: CURSOR csr_trx_currency(cv_customer_trx_id IN NUMBER) IS
3991: SELECT invoice_currency_code
3992: FROM ra_customer_trx
3993: WHERE customer_trx_id = cv_customer_trx_id;
3994:
3995: l_deduction_id NUMBER;
3996: l_amt_due_remaining NUMBER;