APPS.AR_LATE_CHARGE_PKG dependencies on AR_PAYMENT_SCHEDULES

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

966: AND interest_batch_id = g_interest_batch_id
967: AND interest_line_id = l_sucess_line_id(i);
968:
969:
970: log(message => 'Updating ar_payment_schedules late_charge_date for invoice and DM');
971:
972: FORALL i IN l_success_ps_id.FIRST..l_success_ps_id.LAST
973: UPDATE ar_payment_schedules
974: SET last_charge_date = g_int_cal_date

Line 973: UPDATE ar_payment_schedules

969:
970: log(message => 'Updating ar_payment_schedules late_charge_date for invoice and DM');
971:
972: FORALL i IN l_success_ps_id.FIRST..l_success_ps_id.LAST
973: UPDATE ar_payment_schedules
974: SET last_charge_date = g_int_cal_date
975: WHERE payment_schedule_id = l_success_ps_id(i);
976:
977: END IF;

Line 1535: UPDATE ar_payment_schedules

1531: AND header_type IN ('INV','DM')
1532: RETURN interest_batch_id BULK COLLECT INTO l_list_header_in_error;
1533:
1534: log( message => ' update ar_payment_schedule for successfull headers');
1535: UPDATE ar_payment_schedules
1536: SET last_charge_date = g_int_cal_date
1537: WHERE payment_schedule_id IN
1538: (SELECT l.PAYMENT_SCHEDULE_ID
1539: FROM ar_interest_headers h,

Line 1635: ar_payment_schedules psch

1631: FROM ar_interest_lines l,
1632: ar_interest_headers h,
1633: ar_interest_batches b,
1634: ar_receivables_trx rtrx,
1635: ar_payment_schedules psch
1636: WHERE b.interest_batch_id = g_interest_batch_id
1637: AND h.interest_batch_id = b.interest_batch_id
1638: AND l.INTEREST_HEADER_ID = h.INTEREST_HEADER_ID
1639: AND h.HEADER_TYPE = 'ADJ'

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

1886: END LOOP;
1887:
1888: --Update Payment_Schedule Late_Charge_Date HYU
1889: IF l_adjusted_ps.COUNT > 0 THEN
1890: log( message => 'Updating ar_payment_schedules late_charge_date for adjustments');
1891:
1892: FORALL i IN l_adjusted_ps.FIRST .. l_adjusted_ps.LAST
1893: UPDATE ar_payment_schedules
1894: SET last_charge_date = s_cal_int_date

Line 1893: UPDATE ar_payment_schedules

1889: IF l_adjusted_ps.COUNT > 0 THEN
1890: log( message => 'Updating ar_payment_schedules late_charge_date for adjustments');
1891:
1892: FORALL i IN l_adjusted_ps.FIRST .. l_adjusted_ps.LAST
1893: UPDATE ar_payment_schedules
1894: SET last_charge_date = s_cal_int_date
1895: WHERE payment_schedule_id = l_adjusted_ps(i);
1896:
1897: l_adjusted_ps_cnt := 0;

Line 2249: UPDATE ar_payment_schedules

2245: OPEN c_one_doc_success;
2246: FETCH c_one_doc_success INTO l_success_found;
2247: IF c_one_doc_success%FOUND THEN
2248: --{ HYU CDI included in calculation without generating the late charges document
2249: UPDATE ar_payment_schedules
2250: SET last_charge_date = g_int_cal_date
2251: WHERE payment_schedule_id IN
2252: (SELECT l.PAYMENT_SCHEDULE_ID
2253: FROM ar_interest_headers h,

Line 2886: UPDATE ar_payment_schedules

2882: log('l_dm_exist : '||l_dm_exist);
2883:
2884: IF l_dm_exist = 'Y' THEN
2885: --{ HYU CDI included in calculation without generating the late charges document
2886: UPDATE ar_payment_schedules
2887: SET last_charge_date = g_int_cal_date
2888: WHERE payment_schedule_id IN
2889: (SELECT l.PAYMENT_SCHEDULE_ID
2890: FROM ar_interest_headers h,