APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_CHARGE_SCHEDULE_LINES

Line 267: INSERT INTO ar_charge_schedule_lines

263:
264:
265: --dbms_output.put_line('Inserted Rows in ar_aging_bucket_lines_b : '|| SQL%ROWCOUNT);
266:
267: INSERT INTO ar_charge_schedule_lines
268: (
269: schedule_line_id,
270: schedule_header_id,
271: schedule_id,

Line 284: ar_charge_schedule_lines_s.NEXTVAL,

280: last_update_date,
281: last_update_login
282: )
283: VALUES(
284: ar_charge_schedule_lines_s.NEXTVAL,
285: l_schedule_header_id,
286: l_schedule_id,
287: l_aging_bucket_id,
288: l_aging_bucket_line_id,

Line 302: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines : '|| SQL%ROWCOUNT);

298: -1
299: );
300:
301: IF (g_debug_mode = 'Y') THEN
302: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines : '|| SQL%ROWCOUNT);
303: END IF;
304:
305: --dbms_output.put_line('Inserted Rows in ar_charge_schedule_lines : '|| SQL%ROWCOUNT);
306:

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

301: IF (g_debug_mode = 'Y') THEN
302: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines : '|| SQL%ROWCOUNT);
303: END IF;
304:
305: --dbms_output.put_line('Inserted Rows in ar_charge_schedule_lines : '|| SQL%ROWCOUNT);
306:
307: END LOOP;
308:
309: EXCEPTION

Line 494: INSERT INTO ar_charge_schedule_lines

490: IF (g_debug_mode = 'Y') THEN
491: Put_Debug_Msg(l_full_path, 'Aging Bucket Line ID(Site Override): ' || l_aging_bucket_line_id);
492: END IF;
493:
494: INSERT INTO ar_charge_schedule_lines
495: (
496: schedule_line_id,
497: schedule_header_id,
498: schedule_id,

Line 511: ar_charge_schedule_lines_s.NEXTVAL,

507: last_update_date,
508: last_update_login
509: )
510: VALUES(
511: ar_charge_schedule_lines_s.NEXTVAL,
512: l_schedule_header_id,
513: l_schedule_id,
514: l_aging_bucket_id,
515: l_aging_bucket_line_id,

Line 527: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines(Site Override): '|| SQL%ROWCOUNT);

523: SYSDATE,
524: -1
525: );
526: IF (g_debug_mode = 'Y') THEN
527: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines(Site Override): '|| SQL%ROWCOUNT);
528: END IF;
529:
530: END IF;
531:

Line 636: INSERT INTO ar_charge_schedule_lines

632: IF (g_debug_mode = 'Y') THEN
633: Put_Debug_Msg(l_full_path, 'Aging Bucket Line ID (Un Used): ' || l_aging_bucket_line_id);
634: END IF;
635:
636: INSERT INTO ar_charge_schedule_lines
637: (
638: schedule_line_id,
639: schedule_header_id,
640: schedule_id,

Line 653: ar_charge_schedule_lines_s.NEXTVAL,

649: last_update_date,
650: last_update_login
651: )
652: VALUES(
653: ar_charge_schedule_lines_s.NEXTVAL,
654: l_schedule_header_id,
655: l_schedule_id,
656: l_aging_bucket_id,
657: l_aging_bucket_line_id,

Line 671: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines (Un Used): '|| SQL%ROWCOUNT);

667: -1
668: );
669:
670: IF (g_debug_mode = 'Y') THEN
671: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines (Un Used): '|| SQL%ROWCOUNT);
672: END IF;
673:
674: END LOOP; /*FOR r_aging_bkt_lines IN c_aging_bkt_lines*/
675:

Line 838: INSERT INTO ar_charge_schedule_lines

834: IF (g_debug_mode = 'Y') THEN
835: Put_Debug_Msg(l_full_path, 'Aging Bucket Line ID(Site Override - Un Used): ' || l_aging_bucket_line_id);
836: END IF;
837:
838: INSERT INTO ar_charge_schedule_lines
839: (
840: schedule_line_id,
841: schedule_header_id,
842: schedule_id,

Line 855: ar_charge_schedule_lines_s.NEXTVAL,

851: last_update_date,
852: last_update_login
853: )
854: VALUES(
855: ar_charge_schedule_lines_s.NEXTVAL,
856: l_schedule_header_id,
857: l_schedule_id,
858: l_aging_bucket_id,
859: l_aging_bucket_line_id,

Line 871: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines(Site Override - Un Used): '|| SQL%ROWCOUNT);

867: SYSDATE,
868: -1
869: );
870: IF (g_debug_mode = 'Y') THEN
871: Put_Debug_Msg(l_full_path, 'Inserted Rows in ar_charge_schedule_lines(Site Override - Un Used): '|| SQL%ROWCOUNT);
872: END IF;
873:
874: END IF;
875: