eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 143: FROM ra_cust_trx_line_gl_dist dist,

139: AND ps.class = 'CB';
140:
141: SELECT dist.code_combination_id
142: INTO l_adj_rec.code_combination_id
143: FROM ra_cust_trx_line_gl_dist dist,
144: ra_customer_trx ct
145: WHERE ct.customer_trx_id = p_cb_ct_id
146: AND ct.customer_trx_id = dist.customer_trx_id
147: AND dist.account_class = 'REV';

Line 1042: into RA_CUST_TRX_LINE_GL_DIST

1038: 1. Instantiate variables with default values
1039: 2. Insert header RA_CUSTOMER_TRX
1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution
1044: into RA_CUST_TRX_LINE_GL_DIST
1045: 6. Insert into AR_PAYMENT_SCHEDULES
1046: - Call event handler

Line 1044: into RA_CUST_TRX_LINE_GL_DIST

1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution
1044: into RA_CUST_TRX_LINE_GL_DIST
1045: 6. Insert into AR_PAYMENT_SCHEDULES
1046: - Call event handler
1047:
1048: 7. Initialize, then populate app_struct and ps_struct

Line 1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist

1064: ARTITRXB.pls Table handler for ra_customer_trx
1065: - insert_p
1066: ARTICTLB.pls Table handler for ra_customer_trx_lines
1067: - insert_p
1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist
1069: - insert_p
1070: ARTEADJS.pls Adjustment procedures
1071: - insert_adjustment
1072:

Line 1210: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;

1206: IS
1207:
1208: l_ct_row ra_customer_trx%ROWTYPE;
1209: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1210: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1211: l_ps_row ar_payment_schedules%ROWTYPE;
1212: l_adj_row ar_adjustments%ROWTYPE;
1213:
1214: ln_app_payment_schedule_id NUMBER;

Line 1243: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1239: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1240: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1241: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1242: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1243: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1244: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1245: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1246: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1247: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

Line 1246: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1242: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1243: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1244: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1245: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1246: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1247: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1248: --Bug2979254
1249: l_ev_rec arp_xla_events.xla_events_type;
1250: /* Bug 3879127 */

Line 1247: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1243: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1244: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1245: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1246: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1247: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1248: --Bug2979254
1249: l_ev_rec arp_xla_events.xla_events_type;
1250: /* Bug 3879127 */
1251: ln_amount_due_remaining NUMBER;

Line 1404: , ra_cust_trx_line_gl_dist ctlgd

1400: , l_ct_row.legal_entity_id /* R12 LE uptake */
1401: , ln_trx_number /*bug 5550153*/
1402: FROM
1403: ar_payment_schedules ps
1404: , ra_cust_trx_line_gl_dist ctlgd
1405: , ra_customer_trx ct
1406: WHERE
1407: ct.customer_trx_id = p_app_customer_trx_id
1408: AND ct.customer_trx_id = ps.customer_trx_id

Line 1813: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns

1809: -- Insert revenue account distribution
1810: -- ---------------------------------------------------
1811:
1812: -- ---------------------------------------------------
1813: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns
1814: -- The revenue distributions should have an account class
1815: -- of 'REV'
1816: -- ---------------------------------------------------
1817:

Line 1926: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table

1922:
1923: END IF;
1924: l_ctlgd_row.code_combination_id := l_actual_ccid;
1925: -- ---------------------------------------------------
1926: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table
1927: -- ---------------------------------------------------
1928:
1929: arp_ctlgd_pkg.insert_p(
1930: -- IN

Line 1946: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns

1942: -- Insert receivables account distribution
1943: -- ---------------------------------------------------
1944:
1945: -- ---------------------------------------------------
1946: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns
1947: -- The receivables distributions should have an account class
1948: -- of 'REC'.
1949: -- The receivable account distributions records should
1950: -- not have a value in CUSTOMER_TRX_LINE_ID

Line 1971: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table

1967: l_ctlgd_row.ussgl_transaction_code_context :=
1968: l_ct_row.default_ussgl_trx_code_context;
1969:
1970: -- ---------------------------------------------------
1971: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table
1972: -- ---------------------------------------------------
1973: arp_ctlgd_pkg.insert_p(
1974: -- IN
1975: p_dist_rec => l_ctlgd_row