APPS.IEX_DEL_SUB_PVT dependencies on IEX_WRITEOFF_CONTRACTS

Line 131: Update IEX_WRITEOFF_CONTRACTS

127: Elsif p_source_module = 'IEXWOCNT' then
128: FOR i IN 1..nCount
129: LOOP
130: BEGIN
131: Update IEX_WRITEOFF_CONTRACTS
132: SET ACTIVE_YN = 'Y'
133: where contract_id = p_id_tbl(i)
134: AND delinquency_id = p_del_id
135: AND object_id = p_object_id

Line 141: INSERT INTO IEX_WRITEOFF_CONTRACTS

137:
138: IF sql%NOTFOUND THEN
139:
140: BEGIN
141: INSERT INTO IEX_WRITEOFF_CONTRACTS
142: (WRITEOFF_CONTRACT_ID ,
143: LAST_UPDATE_DATE ,
144: LAST_UPDATED_BY ,
145: LAST_UPDATE_LOGIN ,

Line 155: (IEX_WRITEOFF_CONTRACTS_S.NEXTVAL,

151: OBJECT_ID ,
152: ACTIVE_YN ,
153: DELINQUENCY_ID)
154: VALUES
155: (IEX_WRITEOFF_CONTRACTS_S.NEXTVAL,
156: sysdate ,
157: FND_GLOBAL.USER_ID,
158: FND_GLOBAL.LOGIN_ID,
159: sysdate ,

Line 362: UPDATE IEX_WRITEOFF_CONTRACTS

358: WHERE DEL_ASSET_ID = p_id_tbl(cnt) ;
359:
360: Elsif p_source_module = 'IEXWOCNT' then
361: FORALL cnt in 1..nCount
362: UPDATE IEX_WRITEOFF_CONTRACTS
363: SET ACTIVE_YN = 'N'
364: WHERE WRITEOFF_CONTRACT_ID = p_id_tbl(cnt) ;
365:
366: Elsif p_source_module = 'IEXWOINV' then

Line 597: UPDATE IEX_WRITEOFF_CONTRACTS

593: SET ACTIVE_YN = 'N'
594: WHERE DELINQUENCY_ID = p_del_id ;
595:
596: Elsif p_source_module = 'IEXWOCNT' then
597: UPDATE IEX_WRITEOFF_CONTRACTS
598: SET ACTIVE_YN = 'N'
599: WHERE DELINQUENCY_ID = p_del_id ;
600:
601: Elsif p_source_module = 'IEXWOINV' then