APPS.ARP_GROUP_INV dependencies on AR_CONS_INV

Line 80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';

76:
77: old_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;
83:
84: BEGIN

Line 81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';

77: old_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;
83:
84: BEGIN
85:

Line 82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;

78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;
83:
84: BEGIN
85:
86: arp_standard.debug('arp_group_inv.generate()+');

Line 107: FROM ar_cons_inv_trx

103:
104: /* bug3886862 */
105: SELECT nvl(max(cons_inv_line_number),0) + 1
106: INTO l_group_inv_line_number
107: FROM ar_cons_inv_trx
108: WHERE cons_inv_id = new_cons_inv_id ;
109:
110: /* if there is no cons inv with the id, create new record */
111: IF l_group_inv_line_number = 1 THEN

Line 113: INSERT INTO ar_cons_inv

109:
110: /* if there is no cons inv with the id, create new record */
111: IF l_group_inv_line_number = 1 THEN
112:
113: INSERT INTO ar_cons_inv
114: (cons_inv_id,
115: cons_billing_number,
116: customer_id,
117: site_use_id,

Line 156: INSERT INTO ar_cons_inv_trx

152: END IF;
153:
154: END IF; /** New group ***/
155:
156: INSERT INTO ar_cons_inv_trx
157: (cons_inv_id,
158: transaction_type,
159: trx_number,
160: transaction_date,

Line 271: FROM ar_cons_inv

267: FROM ra_interface_lines l
268: WHERE l.request_id = p_request_id
269: AND l.cons_billing_number IS NOT NULL
270: AND (EXISTS (SELECT 'X'
271: FROM ar_cons_inv
272: WHERE cons_billing_number = l.cons_billing_number
273: AND cons_inv_type = 'MINV' )
274: OR
275: EXISTS (SELECT 'X'

Line 443: ar_cons_inv.cons_billing_number%TYPE) IS

439:
440: /* bug3886862 check if there is cons inv with the number */
441: /* bug3895741 modified l_cbi_number type */
442: CURSOR check_cbi_num (l_cbi_number
443: ar_cons_inv.cons_billing_number%TYPE) IS
444: SELECT cons_inv_id
445: FROM ar_cons_inv
446: WHERE cons_billing_number = l_cbi_number
447: AND cons_inv_type = 'MINV';

Line 445: FROM ar_cons_inv

441: /* bug3895741 modified l_cbi_number type */
442: CURSOR check_cbi_num (l_cbi_number
443: ar_cons_inv.cons_billing_number%TYPE) IS
444: SELECT cons_inv_id
445: FROM ar_cons_inv
446: WHERE cons_billing_number = l_cbi_number
447: AND cons_inv_type = 'MINV';
448:
449: l_cons_inv_id ar_cons_inv.cons_inv_id%TYPE;

Line 449: l_cons_inv_id ar_cons_inv.cons_inv_id%TYPE;

445: FROM ar_cons_inv
446: WHERE cons_billing_number = l_cbi_number
447: AND cons_inv_type = 'MINV';
448:
449: l_cons_inv_id ar_cons_inv.cons_inv_id%TYPE;
450: old_cons_billing_number ar_cons_inv.cons_billing_number%TYPE:='$$~$$';
451: l_tot_rec_updated NUMBER:=0;
452:
453: BEGIN

Line 450: old_cons_billing_number ar_cons_inv.cons_billing_number%TYPE:='$$~$$';

446: WHERE cons_billing_number = l_cbi_number
447: AND cons_inv_type = 'MINV';
448:
449: l_cons_inv_id ar_cons_inv.cons_inv_id%TYPE;
450: old_cons_billing_number ar_cons_inv.cons_billing_number%TYPE:='$$~$$';
451: l_tot_rec_updated NUMBER:=0;
452:
453: BEGIN
454: --

Line 469: SELECT ar_cons_inv_s.NEXTVAL INTO l_cons_inv_id FROM dual;

465: /* the cons_billing_number is new */
466: IF check_cbi_num%NOTFOUND
467: THEN
468: --
469: SELECT ar_cons_inv_s.NEXTVAL INTO l_cons_inv_id FROM dual;
470: --
471: END IF;
472: CLOSE check_cbi_num ;
473: