APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_CHARGE_SCHEDULE_HDRS

Line 212: INSERT INTO ar_charge_schedule_hdrs

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,
215: schedule_id,
216: schedule_header_type,

Line 229: ar_charge_schedule_hdrs_s.NEXTVAL,

225: last_update_date,
226: last_update_login
227: )
228: VALUES(
229: ar_charge_schedule_hdrs_s.NEXTVAL,
230: l_schedule_id,
231: 'AMOUNT',
232: l_aging_bucket_id,
233: to_date('01-01-1900', 'DD-MM-YYYY'),

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

245: IF (g_debug_mode = 'Y') THEN
246: Put_Debug_Msg(l_full_path, 'Charge Schedule Header ID: ' || l_schedule_header_id);
247: END IF;
248:
249: --dbms_output.put_line('Inserted Rows in ar_charge_schedule_hdrs : '|| SQL%ROWCOUNT);
250:
251: FOR r_aging_bkt_lines IN c_aging_bkt_lines(r_aging_bkts.dls_id, r_aging_bkts.ccy_code) LOOP
252:
253: SELECT aging_bucket_line_id INTO l_aging_bucket_line_id

Line 436: INSERT INTO ar_charge_schedule_hdrs

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: (
438: schedule_header_id,
439: schedule_id,
440: schedule_header_type,

Line 453: ar_charge_schedule_hdrs_s.NEXTVAL,

449: last_update_date,
450: last_update_login
451: )
452: VALUES(
453: ar_charge_schedule_hdrs_s.NEXTVAL,
454: l_schedule_id,
455: 'AMOUNT',
456: l_aging_bucket_id,
457: to_date('01-01-1900', 'DD-MM-YYYY'),

Line 590: INSERT INTO ar_charge_schedule_hdrs

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: (
592: schedule_header_id,
593: schedule_id,
594: schedule_header_type,

Line 607: ar_charge_schedule_hdrs_s.NEXTVAL,

603: last_update_date,
604: last_update_login
605: )
606: VALUES(
607: ar_charge_schedule_hdrs_s.NEXTVAL,
608: l_schedule_id,
609: 'AMOUNT',
610: l_aging_bucket_id,
611: to_date('01-01-1900', 'DD-MM-YYYY'),

Line 780: INSERT INTO ar_charge_schedule_hdrs

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: (
782: schedule_header_id,
783: schedule_id,
784: schedule_header_type,

Line 797: ar_charge_schedule_hdrs_s.NEXTVAL,

793: last_update_date,
794: last_update_login
795: )
796: VALUES(
797: ar_charge_schedule_hdrs_s.NEXTVAL,
798: l_schedule_id,
799: 'AMOUNT',
800: l_aging_bucket_id,
801: to_date('01-01-1900', 'DD-MM-YYYY'),