[Home] [Help]
947: WHERE interest_line_id = l_line_upg(i);
948:
949:
950: FORALL i IN l_line_upg.FIRST..l_line_upg.LAST
951: UPDATE ar_interest_lines
952: SET process_status = 'E',
953: process_message= l_line_text(i)
954: WHERE interest_line_id = l_line_upg(i);
955: END IF;
1151: l.INTEREST_RATE ,
1152: tty.GL_ID_REV,
1153: p_worker_num
1154: FROM ar_interest_headers h,
1155: ar_interest_lines l,
1156: ar_system_parameters sp,
1157: ra_cust_trx_types tty
1158: WHERE h.interest_batch_id = g_interest_batch_id
1159: AND h.INTEREST_HEADER_ID = l.INTEREST_HEADER_ID
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,
1540: ar_interest_lines l
1541: WHERE h.interest_batch_id = g_interest_batch_id
1542: AND h.process_status = 'S'
1543: AND h.display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1544: AND DECODE(p_worker_num,NULL,NVL(h.worker_num,-9),p_worker_num)=NVL(h.worker_num,-9)
1627: g_interest_batch_id,
1628: 'I',
1629: header_type,
1630: p_worker_num
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
1906: LINE_ERR_MSG = l_process_msg(i)
1907: WHERE interest_line_id = l_interest_line_id(i)
1908: AND interest_batch_id = g_interest_batch_id;
1909:
1910: log( message => 'Updating ar_interest_lines process_status for adjustment');
1911:
1912: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1913: UPDATE ar_interest_lines
1914: SET PROCESS_STATUS = l_process_status(i),
1909:
1910: log( message => 'Updating ar_interest_lines process_status for adjustment');
1911:
1912: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1913: UPDATE ar_interest_lines
1914: SET PROCESS_STATUS = l_process_status(i),
1915: PROCESS_MESSAGE = l_process_msg(i)
1916: WHERE interest_line_id = l_interest_line_id(i);
1917: END IF;
1945: AND a.header_type = 'ADJ'
1946: AND a.display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1947: AND EXISTS
1948: (SELECT NULL
1949: FROM ar_interest_lines b
1950: WHERE b.interest_header_id = a.interest_header_id
1951: AND b.process_status = 'E');
1952:
1953: log( message => 'Updating ar_interest_headers for adjustment in Success');
2171: SET a.process_message = ''
2172: WHERE a.interest_batch_id = p_batch_id
2173: AND a.display_flag = 'Y'; --HYU CDI only document generating the Late Charge s Doc
2174:
2175: UPDATE ar_interest_lines a
2176: SET a.process_message = ''
2177: WHERE a.interest_header_id IN
2178: (SELECT interest_header_id
2179: FROM ar_interest_headers
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,
2254: ar_interest_lines l
2255: WHERE h.interest_batch_id = g_interest_batch_id
2256: AND h.display_flag = 'N' -- Document included in Late Charges Calculation
2257: AND h.process_status = 'N'
2258: AND h.interest_header_id = l.interest_header_id);
2796: AND a.worker_num = p_worker_num
2797: AND a.display_flag = 'Y'; -- Document generating a Late Charges Document
2798: -- no need to include Credit Debit items
2799: -- as no error messages will be tied to such an item
2800: UPDATE ar_interest_lines a
2801: SET a.process_message = ''
2802: WHERE a.interest_header_id IN
2803: (SELECT interest_header_id
2804: FROM ar_interest_headers
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,
2891: ar_interest_lines l
2892: WHERE h.interest_batch_id = g_interest_batch_id
2893: AND h.display_flag = 'N' -- Document included in Late Charges Calculation
2894: AND h.process_status = 'N'
2895: AND h.interest_header_id = l.interest_header_id);