APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_AGING_BUCKETS

Line 29: l_aging_bct_id ar_aging_buckets.aging_bucket_id%TYPE;

25: l_name ar_dunning_letter_sets.name%TYPE;
26: l_old_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;
27: l_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;
28: l_old_customer_profile_id NUMBER;
29: l_aging_bct_id ar_aging_buckets.aging_bucket_id%TYPE;
30: l_not_exists BOOLEAN;
31: l_length NUMBER;
32:
33: l_full_path VARCHAR2(255);

Line 41: SELECT ar_aging_buckets_s.NEXTVAL INTO l_aging_bct_id

37: l_full_path := g_path || 'DUNNING_UPG';
38:
39: FOR r_bkts IN c_bkts LOOP
40:
41: SELECT ar_aging_buckets_s.NEXTVAL INTO l_aging_bct_id
42: FROM dual;
43:
44: l_length := length(to_char(l_aging_bct_id));
45:

Line 46: INSERT INTO ar_aging_buckets

42: FROM dual;
43:
44: l_length := length(to_char(l_aging_bct_id));
45:
46: INSERT INTO ar_aging_buckets
47: (
48: aging_bucket_id,
49: bucket_name,
50: status,

Line 203: FROM ar_aging_buckets

199:
200: --dbms_output.put_line('Updated Rows in hz_cust_profile_amts : '|| SQL%ROWCOUNT);
201:
202: SELECT aging_bucket_id INTO l_aging_bucket_id
203: FROM ar_aging_buckets
204: WHERE description = r_aging_bkts.name;
205:
206: IF (g_debug_mode = 'Y') THEN
207: Put_Debug_Msg(l_full_path, 'Aging bucket ID: ' || l_aging_bucket_id);

Line 210: --dbms_output.put_line('Inserted Rows in ar_aging_buckets : '|| SQL%ROWCOUNT);

206: IF (g_debug_mode = 'Y') THEN
207: Put_Debug_Msg(l_full_path, 'Aging bucket ID: ' || l_aging_bucket_id);
208: END IF;
209:
210: --dbms_output.put_line('Inserted Rows in ar_aging_buckets : '|| SQL%ROWCOUNT);
211:
212: INSERT INTO ar_charge_schedule_hdrs
213: (
214: schedule_header_id,

Line 433: SELECT aging_bucket_id INTO l_aging_bucket_id FROM ar_aging_buckets

429: AND hcpa.cust_account_profile_id = r_aging_bkt_lines_site.customer_profile_id
430: AND hcpa.currency_code = r_aging_bkt_lines_site.ccy_code
431: AND NVL(hcpa.site_use_id, -99) = NVL(r_aging_bkt_lines_site.site_use_id, -99));
432:
433: SELECT aging_bucket_id INTO l_aging_bucket_id FROM ar_aging_buckets
434: WHERE description = r_aging_bkt_lines_site.name;
435:
436: INSERT INTO ar_charge_schedule_hdrs
437: (

Line 587: FROM ar_aging_buckets

583: Put_Debug_Msg(l_full_path, 'Schedule ID (Un Used): ' || l_schedule_id);
584: END IF;
585:
586: SELECT aging_bucket_id INTO l_aging_bucket_id
587: FROM ar_aging_buckets
588: WHERE description = r_aging_bkts_uu.name;
589:
590: INSERT INTO ar_charge_schedule_hdrs
591: (

Line 777: SELECT aging_bucket_id INTO l_aging_bucket_id FROM ar_aging_buckets

773: Put_Debug_Msg(l_full_path, 'Customer Profile ID(Site Override - Un Used): ' || r_aging_bkt_lines_site.customer_profile_id);
774: Put_Debug_Msg(l_full_path, 'Schedule ID(Site Override - Un Used): ' || l_schedule_id);
775: END IF;
776:
777: SELECT aging_bucket_id INTO l_aging_bucket_id FROM ar_aging_buckets
778: WHERE description = r_aging_bkt_lines_site.name;
779:
780: INSERT INTO ar_charge_schedule_hdrs
781: (