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 1207: l_ctl_row ra_customer_trx_lines%ROWTYPE;

1203: )
1204: IS
1205:
1206: l_ct_row ra_customer_trx%ROWTYPE;
1207: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1208: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1209: l_ps_row ar_payment_schedules%ROWTYPE;
1210: l_adj_row ar_adjustments%ROWTYPE;
1211:

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

1585: arp_standard.debug ( '');
1586: END IF;
1587:
1588: -- ---------------------------------------------------
1589: -- Get line type info for RA_CUSTOMER_TRX_LINES columns
1590: -- - memo_line_id = 1 means chargeback memo line
1591: -- ---------------------------------------------------
1592: IF p_app_customer_trx_id <> -4 THEN
1593: BEGIN

Line 1652: -- Set values for RA_CUSTOMER_TRX_LINES columns

1648: END;
1649: END IF;
1650:
1651: -- ---------------------------------------------------
1652: -- Set values for RA_CUSTOMER_TRX_LINES columns
1653: -- ---------------------------------------------------
1654:
1655: l_ctl_row.customer_trx_id := l_ct_row.customer_trx_id;
1656: l_ctl_row.line_number := 1;

Line 1671: -- Insert line into RA_CUSTOMER_TRX_LINES table

1667: l_ct_row.default_ussgl_trx_code_context;
1668: l_ctl_row.set_of_books_id := p_set_of_books_id;
1669:
1670: -- ---------------------------------------------------
1671: -- Insert line into RA_CUSTOMER_TRX_LINES table
1672: -- ---------------------------------------------------
1673:
1674: arp_ctl_pkg.insert_p(
1675: -- IN