[Home] [Help]
923: WHERE interest_line_id = l_line_upg(i);
924:
925:
926: FORALL i IN l_line_upg.FIRST..l_line_upg.LAST
927: UPDATE ar_interest_lines
928: SET process_status = 'E',
929: process_message= l_line_text(i)
930: WHERE interest_line_id = l_line_upg(i);
931: END IF;
1123: l.INTEREST_RATE ,
1124: tty.GL_ID_REV,
1125: p_worker_num
1126: FROM ar_interest_headers h,
1127: ar_interest_lines l,
1128: ar_system_parameters sp,
1129: ra_cust_trx_types tty
1130: WHERE h.interest_batch_id = g_interest_batch_id
1131: AND h.INTEREST_HEADER_ID = l.INTEREST_HEADER_ID
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,
1505: ar_interest_lines l
1506: WHERE h.interest_batch_id = g_interest_batch_id
1507: AND h.process_status = 'S'
1508: AND h.display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1509: AND DECODE(p_worker_num,NULL,NVL(h.worker_num,-9),p_worker_num)=NVL(h.worker_num,-9)
1587: g_interest_batch_id,
1588: 'I',
1589: header_type,
1590: p_worker_num
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
1866: LINE_ERR_MSG = l_process_msg(i)
1867: WHERE interest_line_id = l_interest_line_id(i)
1868: AND interest_batch_id = g_interest_batch_id;
1869:
1870: log( message => 'Updating ar_interest_lines process_status for adjustment');
1871:
1872: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1873: UPDATE ar_interest_lines
1874: SET PROCESS_STATUS = l_process_status(i),
1869:
1870: log( message => 'Updating ar_interest_lines process_status for adjustment');
1871:
1872: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1873: UPDATE ar_interest_lines
1874: SET PROCESS_STATUS = l_process_status(i),
1875: PROCESS_MESSAGE = l_process_msg(i)
1876: WHERE interest_line_id = l_interest_line_id(i);
1877: END IF;
1905: AND a.header_type = 'ADJ'
1906: AND a.display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1907: AND EXISTS
1908: (SELECT NULL
1909: FROM ar_interest_lines b
1910: WHERE b.interest_header_id = a.interest_header_id
1911: AND b.process_status = 'E');
1912:
1913: log( message => 'Updating ar_interest_headers for adjustment in Success');
2131: SET a.process_message = ''
2132: WHERE a.interest_batch_id = p_batch_id
2133: AND a.display_flag = 'Y'; --HYU CDI only document generating the Late Charge s Doc
2134:
2135: UPDATE ar_interest_lines a
2136: SET a.process_message = ''
2137: WHERE a.interest_header_id IN
2138: (SELECT interest_header_id
2139: FROM ar_interest_headers
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,
2214: ar_interest_lines l
2215: WHERE h.interest_batch_id = g_interest_batch_id
2216: AND h.display_flag = 'N' -- Document included in Late Charges Calculation
2217: AND h.process_status = 'N'
2218: AND h.interest_header_id = l.interest_header_id);
2756: AND a.worker_num = p_worker_num
2757: AND a.display_flag = 'Y'; -- Document generating a Late Charges Document
2758: -- no need to include Credit Debit items
2759: -- as no error messages will be tied to such an item
2760: UPDATE ar_interest_lines a
2761: SET a.process_message = ''
2762: WHERE a.interest_header_id IN
2763: (SELECT interest_header_id
2764: FROM ar_interest_headers
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,
2851: ar_interest_lines l
2852: WHERE h.interest_batch_id = g_interest_batch_id
2853: AND h.display_flag = 'N' -- Document included in Late Charges Calculation
2854: AND h.process_status = 'N'
2855: AND h.interest_header_id = l.interest_header_id);