APPS.AR_LATE_CHARGE_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 946: log(message => 'Updating ar_payment_schedules late_charge_date for invoice and DM');

942: AND interest_batch_id = g_interest_batch_id
943: AND interest_line_id = l_sucess_line_id(i);
944:
945:
946: log(message => 'Updating ar_payment_schedules late_charge_date for invoice and DM');
947:
948: FORALL i IN l_success_ps_id.FIRST..l_success_ps_id.LAST
949: UPDATE ar_payment_schedules
950: SET last_charge_date = g_int_cal_date

Line 949: UPDATE ar_payment_schedules

945:
946: log(message => 'Updating ar_payment_schedules late_charge_date for invoice and DM');
947:
948: FORALL i IN l_success_ps_id.FIRST..l_success_ps_id.LAST
949: UPDATE ar_payment_schedules
950: SET last_charge_date = g_int_cal_date
951: WHERE payment_schedule_id = l_success_ps_id(i);
952:
953: END IF;

Line 1500: UPDATE ar_payment_schedules

1496: AND header_type IN ('INV','DM')
1497: RETURN interest_batch_id BULK COLLECT INTO l_list_header_in_error;
1498:
1499: log( message => ' update ar_payment_schedule for successfull headers');
1500: UPDATE ar_payment_schedules
1501: SET last_charge_date = g_int_cal_date
1502: WHERE payment_schedule_id IN
1503: (SELECT l.PAYMENT_SCHEDULE_ID
1504: FROM ar_interest_headers h,

Line 1595: ar_payment_schedules psch

1591: FROM ar_interest_lines l,
1592: ar_interest_headers h,
1593: ar_interest_batches b,
1594: ar_receivables_trx rtrx,
1595: ar_payment_schedules psch
1596: WHERE b.interest_batch_id = g_interest_batch_id
1597: AND h.interest_batch_id = b.interest_batch_id
1598: AND l.INTEREST_HEADER_ID = h.INTEREST_HEADER_ID
1599: AND h.HEADER_TYPE = 'ADJ'

Line 1850: log( message => 'Updating ar_payment_schedules late_charge_date for adjustments');

1846: END LOOP;
1847:
1848: --Update Payment_Schedule Late_Charge_Date HYU
1849: IF l_adjusted_ps.COUNT > 0 THEN
1850: log( message => 'Updating ar_payment_schedules late_charge_date for adjustments');
1851:
1852: FORALL i IN l_adjusted_ps.FIRST .. l_adjusted_ps.LAST
1853: UPDATE ar_payment_schedules
1854: SET last_charge_date = s_cal_int_date

Line 1853: UPDATE ar_payment_schedules

1849: IF l_adjusted_ps.COUNT > 0 THEN
1850: log( message => 'Updating ar_payment_schedules late_charge_date for adjustments');
1851:
1852: FORALL i IN l_adjusted_ps.FIRST .. l_adjusted_ps.LAST
1853: UPDATE ar_payment_schedules
1854: SET last_charge_date = s_cal_int_date
1855: WHERE payment_schedule_id = l_adjusted_ps(i);
1856:
1857: l_adjusted_ps_cnt := 0;

Line 2209: UPDATE ar_payment_schedules

2205: OPEN c_one_doc_success;
2206: FETCH c_one_doc_success INTO l_success_found;
2207: IF c_one_doc_success%FOUND THEN
2208: --{ HYU CDI included in calculation without generating the late charges document
2209: UPDATE ar_payment_schedules
2210: SET last_charge_date = g_int_cal_date
2211: WHERE payment_schedule_id IN
2212: (SELECT l.PAYMENT_SCHEDULE_ID
2213: FROM ar_interest_headers h,

Line 2846: UPDATE ar_payment_schedules

2842: log('l_dm_exist : '||l_dm_exist);
2843:
2844: IF l_dm_exist = 'Y' THEN
2845: --{ HYU CDI included in calculation without generating the late charges document
2846: UPDATE ar_payment_schedules
2847: SET last_charge_date = g_int_cal_date
2848: WHERE payment_schedule_id IN
2849: (SELECT l.PAYMENT_SCHEDULE_ID
2850: FROM ar_interest_headers h,