DBA Data[Home] [Help]

APPS.ARP_CTLS_PKG dependencies on RA_CUSTOMER_TRX_LINES

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 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 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 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 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 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 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 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(+)