DBA Data[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on RA_CUSTOMER_TRX_LINES

Line 1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES

1036:
1037: The algorithm for creating chargebacks:
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

Line 1066: ARTICTLB.pls Table handler for ra_customer_trx_lines

1062: ARCUTILB.pls
1063: - validate_gl_date
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

Line 1209: l_ctl_row ra_customer_trx_lines%ROWTYPE;

1205: )
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:

Line 1716: -- Get line type info for RA_CUSTOMER_TRX_LINES columns

1712: END IF;
1713: /*Bug 13788971 - Payment Intrument details population - End*/
1714:
1715: -- ---------------------------------------------------
1716: -- Get line type info for RA_CUSTOMER_TRX_LINES columns
1717: -- - memo_line_id = 1 means chargeback memo line
1718: -- ---------------------------------------------------
1719: IF p_app_customer_trx_id <> -4 THEN
1720: BEGIN

Line 1779: -- Set values for RA_CUSTOMER_TRX_LINES columns

1775: END;
1776: END IF;
1777:
1778: -- ---------------------------------------------------
1779: -- Set values for RA_CUSTOMER_TRX_LINES columns
1780: -- ---------------------------------------------------
1781:
1782: l_ctl_row.customer_trx_id := l_ct_row.customer_trx_id;
1783: l_ctl_row.line_number := 1;

Line 1798: -- Insert line into RA_CUSTOMER_TRX_LINES table

1794: l_ct_row.default_ussgl_trx_code_context;
1795: l_ctl_row.set_of_books_id := p_set_of_books_id;
1796:
1797: -- ---------------------------------------------------
1798: -- Insert line into RA_CUSTOMER_TRX_LINES table
1799: -- ---------------------------------------------------
1800:
1801: arp_ctl_pkg.insert_p(
1802: -- IN