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.

APPS.ARP_CTLS_PKG dependencies on RA_CUSTOMER_TRX

Line 67: ra_customer_trx.customer_trx_id%type,

63:
64: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
65: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
66: p_customer_trx_id IN
67: ra_customer_trx.customer_trx_id%type,
68: p_customer_trx_line_id IN
69: ra_customer_trx_lines.customer_trx_line_id%type)
70: IS
71:

Line 69: ra_customer_trx_lines.customer_trx_line_id%type)

65: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
66: p_customer_trx_id IN
67: ra_customer_trx.customer_trx_id%type,
68: p_customer_trx_line_id IN
69: ra_customer_trx_lines.customer_trx_line_id%type)
70: IS
71:
72: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
73: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 946: ra_customer_trx_lines.customer_trx_line_id%type)

942: +===========================================================================*/
943:
944:
945: PROCEDURE display_salescredit_f_ctl_id( p_customer_trx_line_id IN
946: ra_customer_trx_lines.customer_trx_line_id%type)
947: IS
948:
949:
950: CURSOR srep_cursor IS

Line 1402: IN ra_customer_trx.customer_trx_id%type )

1398: | |
1399: +===========================================================================*/
1400:
1401: PROCEDURE lock_f_ct_id( p_customer_trx_id
1402: IN ra_customer_trx.customer_trx_id%type )
1403: IS
1404:
1405: CURSOR LOCK_C IS
1406: SELECT cust_trx_line_salesrep_id

Line 1454: IN ra_customer_trx_lines.customer_trx_line_id%type)

1450: | |
1451: +===========================================================================*/
1452:
1453: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1454: IN ra_customer_trx_lines.customer_trx_line_id%type)
1455: IS
1456:
1457: CURSOR lock_c IS
1458: SELECT cust_trx_line_salesrep_id

Line 2063: IN ra_customer_trx_lines.customer_trx_line_id%type )

2059:
2060: procedure delete_p( p_cust_trx_line_salesrep_id
2061: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2062: p_customer_trx_line_id
2063: IN ra_customer_trx_lines.customer_trx_line_id%type )
2064: IS
2065:
2066: rows NUMBER;
2067:

Line 2141: IN ra_customer_trx.customer_trx_id%type,

2137: | |
2138: +===========================================================================*/
2139:
2140: procedure delete_f_ct_id( p_customer_trx_id
2141: IN ra_customer_trx.customer_trx_id%type,
2142: p_delete_default_recs_flag IN boolean DEFAULT TRUE)
2143: IS
2144:
2145: CURSOR srep_trx_cursor IS

Line 2228: IN ra_customer_trx_lines.customer_trx_line_id%type)

2224: | |
2225: +===========================================================================*/
2226:
2227: procedure delete_f_ctl_id( p_customer_trx_line_id
2228: IN ra_customer_trx_lines.customer_trx_line_id%type)
2229: IS
2230:
2231: CURSOR srep_cursor IS
2232: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

Line 2357: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)

2353: | |
2354: +===========================================================================*/
2355:
2356: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2357: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
2358: IS
2359:
2360: CURSOR srep_trx_cursor IS
2361: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

Line 2424: ra_customer_trx_lines.customer_trx_line_id%type)

2420: +===========================================================================*/
2421:
2422: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2423: p_customer_trx_line_id IN
2424: ra_customer_trx_lines.customer_trx_line_id%type)
2425: IS
2426:
2427: CURSOR srep_cursor IS
2428: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

Line 2558: ra_customer_trx_lines.customer_trx_line_id%type,

2554: +===========================================================================*/
2555:
2556: PROCEDURE update_amounts_f_ctl_id(
2557: p_customer_trx_line_id IN
2558: ra_customer_trx_lines.customer_trx_line_id%type,
2559: p_line_amount IN
2560: ra_customer_trx_lines.extended_amount%type,
2561: p_foreign_currency_code IN
2562: fnd_currencies.currency_code%type)

Line 2560: ra_customer_trx_lines.extended_amount%type,

2556: PROCEDURE update_amounts_f_ctl_id(
2557: p_customer_trx_line_id IN
2558: ra_customer_trx_lines.customer_trx_line_id%type,
2559: p_line_amount IN
2560: ra_customer_trx_lines.extended_amount%type,
2561: p_foreign_currency_code IN
2562: fnd_currencies.currency_code%type)
2563: IS
2564:

Line 2800: ra_customer_trx_lines.customer_trx_id%type,

2796: +===========================================================================*/
2797:
2798: PROCEDURE insert_f_ct_ctl_id(
2799: p_customer_trx_id IN
2800: ra_customer_trx_lines.customer_trx_id%type,
2801: p_customer_trx_line_id IN
2802: ra_customer_trx_lines.customer_trx_line_id%type
2803: ) IS
2804:

Line 2802: ra_customer_trx_lines.customer_trx_line_id%type

2798: PROCEDURE insert_f_ct_ctl_id(
2799: p_customer_trx_id IN
2800: ra_customer_trx_lines.customer_trx_id%type,
2801: p_customer_trx_line_id IN
2802: ra_customer_trx_lines.customer_trx_line_id%type
2803: ) IS
2804:
2805:
2806: BEGIN

Line 2893: FROM ra_customer_trx ct,

2889: ct.invoice_currency_code
2890: ),
2891: ctls.non_revenue_salesgroup_id,
2892: ct.org_id
2893: FROM ra_customer_trx ct,
2894: ra_cust_trx_line_salesreps ctls,
2895: ra_customer_trx_lines ctl
2896: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2897: AND ctl.customer_trx_id = ct.customer_trx_id

Line 2895: ra_customer_trx_lines ctl

2891: ctls.non_revenue_salesgroup_id,
2892: ct.org_id
2893: FROM ra_customer_trx ct,
2894: ra_cust_trx_line_salesreps ctls,
2895: ra_customer_trx_lines ctl
2896: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2897: AND ctl.customer_trx_id = ct.customer_trx_id
2898: AND ct.customer_trx_id = p_customer_trx_id
2899: AND ctl.line_type = 'LINE'

Line 2987: FROM ra_customer_trx ct,

2983: ct.invoice_currency_code
2984: )
2985: ,ctls.non_revenue_salesgroup_id
2986: ,ct.org_id
2987: FROM ra_customer_trx ct,
2988: ra_cust_trx_line_salesreps ctls,
2989: ra_customer_trx_lines ctl
2990: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2991: AND ctl.customer_trx_id = ct.customer_trx_id

Line 2989: ra_customer_trx_lines ctl

2985: ,ctls.non_revenue_salesgroup_id
2986: ,ct.org_id
2987: FROM ra_customer_trx ct,
2988: ra_cust_trx_line_salesreps ctls,
2989: ra_customer_trx_lines ctl
2990: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2991: AND ctl.customer_trx_id = ct.customer_trx_id
2992: AND ct.customer_trx_id = p_customer_trx_id
2993: AND ctl.line_type = 'LINE'

Line 3052: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3048: | |
3049: +===========================================================================*/
3050:
3051: PROCEDURE insert_f_cm_ct_ctl_id(
3052: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3053: p_customer_trx_line_id IN
3054: ra_customer_trx_lines.customer_trx_line_id%type,
3055: p_currency_code IN fnd_currencies.currency_code%type
3056: ) IS

Line 3054: ra_customer_trx_lines.customer_trx_line_id%type,

3050:
3051: PROCEDURE insert_f_cm_ct_ctl_id(
3052: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3053: p_customer_trx_line_id IN
3054: ra_customer_trx_lines.customer_trx_line_id%type,
3055: p_currency_code IN fnd_currencies.currency_code%type
3056: ) IS
3057: BEGIN
3058:

Line 3118: ra_customer_trx_lines ctl,

3114: p_currency_code
3115: ) /* non_revenue_amount_split */
3116: ,cm_ct.org_id
3117: FROM ra_cust_trx_line_salesreps prev_ctls,
3118: ra_customer_trx_lines ctl,
3119: ra_customer_trx cm_ct
3120: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3121: AND ctl.previous_customer_trx_line_id =
3122: prev_ctls.customer_trx_line_id(+)

Line 3119: ra_customer_trx cm_ct

3115: ) /* non_revenue_amount_split */
3116: ,cm_ct.org_id
3117: FROM ra_cust_trx_line_salesreps prev_ctls,
3118: ra_customer_trx_lines ctl,
3119: ra_customer_trx cm_ct
3120: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3121: AND ctl.previous_customer_trx_line_id =
3122: prev_ctls.customer_trx_line_id(+)
3123: AND ctl.customer_trx_id = p_customer_trx_id

Line 3174: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3170: | 19-NOV-02 J Beckett Bug 2543675 - change backed out. |
3171: | |
3172: +===========================================================================*/
3173: PROCEDURE insert_f_cmn_ct_ctl_id(
3174: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3175: p_customer_trx_line_id IN
3176: ra_customer_trx_lines.customer_trx_line_id%type
3177: ) IS
3178: BEGIN

Line 3176: ra_customer_trx_lines.customer_trx_line_id%type

3172: +===========================================================================*/
3173: PROCEDURE insert_f_cmn_ct_ctl_id(
3174: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3175: p_customer_trx_line_id IN
3176: ra_customer_trx_lines.customer_trx_line_id%type
3177: ) IS
3178: BEGIN
3179:
3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');

Line 3255: ra_customer_trx_lines ctl,

3251: cm_ct.invoice_currency_code
3252: ) /* non_revenue_amount_split */
3253: ,cm_ct.org_id
3254: FROM ra_cust_trx_line_salesreps prev_ctls,
3255: ra_customer_trx_lines ctl,
3256: ra_customer_trx cm_ct
3257: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3258: AND ctl.previous_customer_trx_line_id =
3259: prev_ctls.customer_trx_line_id(+)

Line 3256: ra_customer_trx cm_ct

3252: ) /* non_revenue_amount_split */
3253: ,cm_ct.org_id
3254: FROM ra_cust_trx_line_salesreps prev_ctls,
3255: ra_customer_trx_lines ctl,
3256: ra_customer_trx cm_ct
3257: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3258: AND ctl.previous_customer_trx_line_id =
3259: prev_ctls.customer_trx_line_id(+)
3260: AND ctl.customer_trx_id = p_customer_trx_id