APPS.IEX_DEL_SUB_PVT dependencies on IEX_WRITEOFF_INVOICES

Line 199: Update IEX_WRITEOFF_INVOICES

195: Elsif p_source_module = 'IEXWOINV' then
196: FOR i IN 1..nCount
197: LOOP
198: Begin
199: Update IEX_WRITEOFF_INVOICES
200: SET ACTIVE_YN = 'Y'
201: where lease_inv_line_id = p_id_tbl(i)
202: AND delinquency_id = p_del_id
203: AND object_id = p_object_id

Line 209: INSERT INTO IEX_WRITEOFF_INVOICES

205:
206: IF sql%NOTFOUND THEN
207:
208: BEGIN
209: INSERT INTO IEX_WRITEOFF_INVOICES
210: (WRITEOFF_INVOICE_ID ,
211: LAST_UPDATE_DATE ,
212: LAST_UPDATED_BY ,
213: LAST_UPDATE_LOGIN ,

Line 223: (IEX_WRITEOFF_INVOICES_S.NEXTVAL,

219: OBJECT_ID ,
220: ACTIVE_YN ,
221: DELINQUENCY_ID)
222: VALUES
223: (IEX_WRITEOFF_INVOICES_S.NEXTVAL,
224: sysdate,
225: FND_GLOBAL.USER_ID,
226: FND_GLOBAL.LOGIN_ID,
227: sysdate,

Line 368: UPDATE IEX_WRITEOFF_INVOICES

364: WHERE WRITEOFF_CONTRACT_ID = p_id_tbl(cnt) ;
365:
366: Elsif p_source_module = 'IEXWOINV' then
367: FORALL cnt in 1..nCount
368: UPDATE IEX_WRITEOFF_INVOICES
369: SET ACTIVE_YN = 'N'
370: WHERE WRITEOFF_INVOICE_ID = p_id_tbl(cnt) ;
371:
372: End If ;

Line 602: UPDATE IEX_WRITEOFF_INVOICES

598: SET ACTIVE_YN = 'N'
599: WHERE DELINQUENCY_ID = p_del_id ;
600:
601: Elsif p_source_module = 'IEXWOINV' then
602: UPDATE IEX_WRITEOFF_INVOICES
603: SET ACTIVE_YN = 'N'
604: WHERE DELINQUENCY_ID = p_del_id ;
605:
606: End IF ;