APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_CHARGE_SCHEDULES

Line 112: INSERT INTO ar_charge_schedules

108: FOR r_aging_bkts IN c_aging_bkts LOOP
109:
110: BEGIN
111:
112: INSERT INTO ar_charge_schedules
113: (
114: schedule_id,
115: schedule_name,
116: schedule_description,

Line 125: ar_charge_schedules_s.NEXTVAL, -- schedule_id

121: last_update_date,
122: last_update_login
123: )
124: VALUES(
125: ar_charge_schedules_s.NEXTVAL, -- schedule_id
126: r_aging_bkts.name || '_' || r_aging_bkts.ccy_code, -- schedule_name
127: r_aging_bkts.name || '_' || r_aging_bkts.ccy_code, -- schedule_description
128: 1, -- object_version_number
129: -1, -- created_by

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

139: Put_Debug_Msg(l_full_path, 'Currency Code: ' || r_aging_bkts.ccy_code);
140: Put_Debug_Msg(l_full_path, 'Dunning Letter Set ID: ' || r_aging_bkts.dls_id);
141: Put_Debug_Msg(l_full_path, 'Schedule ID: ' || l_schedule_id);
142: END IF;
143: --dbms_output.put_line('Inserted Rows in ar_charge_schedules : '|| SQL%ROWCOUNT);
144:
145:
146: UPDATE hz_cust_profile_amts hcpa
147: SET (interest_type, /*interest_fixed_amount,*/ interest_schedule_id,

Line 356: FROM ar_charge_schedules acs

352: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
353: AND idlsc.currency_code = r_aging_bkt_lines_site.ccy_code
354: AND idls.use_dunning_flag = 'Y'
355: AND NOT EXISTS (SELECT 'Y'
356: FROM ar_charge_schedules acs
357: WHERE acs.schedule_name = adls.name || '_' || idlsc.currency_code || '_' || r_aging_bkt_lines_site.customer_profile_id);
358: EXCEPTION
359:
360: WHEN NO_DATA_FOUND THEN

Line 379: INSERT INTO ar_charge_schedules

375: IF (g_debug_mode = 'Y') THEN
376: Put_Debug_Msg(l_full_path, 'Creating new Charge Schedule for Dunning Letter Set ID: ' || r_aging_bkt_lines_site.dunning_letter_set_id || ' and Currency: ' ||r_aging_bkt_lines_site.ccy_code );
377: END IF;
378:
379: INSERT INTO ar_charge_schedules
380: (
381: schedule_id,
382: schedule_name,
383: schedule_description,

Line 392: ar_charge_schedules_s.NEXTVAL, -- schedule_id

388: last_update_date,
389: last_update_login
390: )
391: VALUES(
392: ar_charge_schedules_s.NEXTVAL, -- schedule_id
393: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id, -- schedule_name
394: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id, -- schedule_description
395: 1, -- object_version_number
396: -1, -- created_by

Line 552: INSERT INTO ar_charge_schedules

548: FOR r_aging_bkts_uu IN c_aging_bkts_uu LOOP
549:
550: BEGIN
551:
552: INSERT INTO ar_charge_schedules
553: (
554: schedule_id,
555: schedule_name,
556: schedule_description,

Line 565: ar_charge_schedules_s.NEXTVAL,

561: last_update_date,
562: last_update_login
563: )
564: VALUES(
565: ar_charge_schedules_s.NEXTVAL,
566: r_aging_bkts_uu.name || '_' || r_aging_bkts_uu.ccy_code || '_'
567: || decode(r_aging_bkts_uu.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'),
568: r_aging_bkts_uu.name || '_' || r_aging_bkts_uu.ccy_code|| '_'
569: || decode(r_aging_bkts_uu.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'),

Line 718: FROM ar_charge_schedules acs

714: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
715: AND idlsc.currency_code = r_aging_bkt_lines_site.ccy_code
716: AND idls.use_dunning_flag = 'Y'
717: AND NOT EXISTS (SELECT 'Y'
718: FROM ar_charge_schedules acs
719: WHERE acs.schedule_name = adls.name || '_' || idlsc.currency_code || '_' || r_aging_bkt_lines_site.customer_profile_id || '_'
720: || decode(r_aging_bkt_lines_site.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'));
721: EXCEPTION
722:

Line 742: INSERT INTO ar_charge_schedules

738: IF (g_debug_mode = 'Y') THEN
739: Put_Debug_Msg(l_full_path, 'Creating new Charge Schedule for Dunning Letter Set ID (Site Override - Un Used): ' || r_aging_bkt_lines_site.dunning_letter_set_id || ' and Currency: ' ||r_aging_bkt_lines_site.ccy_code );
740: END IF;
741:
742: INSERT INTO ar_charge_schedules
743: (
744: schedule_id,
745: schedule_name,
746: schedule_description,

Line 755: ar_charge_schedules_s.NEXTVAL, -- schedule_id

751: last_update_date,
752: last_update_login
753: )
754: VALUES(
755: ar_charge_schedules_s.NEXTVAL, -- schedule_id
756: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id || '_'
757: || decode(r_aging_bkt_lines_site.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'), -- schedule_name
758: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id || '_'
759: || decode(r_aging_bkt_lines_site.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'), -- schedule_description