APPS.IEX_DEL_SUB_PVT dependencies on IEX_DEL_ASSETS

Line 23: p_object_id IN IEX_DEL_ASSETS.object_id%TYPE )

19: p_source_module IN VARCHAR2 ,
20: p_id_tbl IN IEX_UTILITIES.t_numbers,
21: p_del_id IN Number ,
22: p_object_code IN Varchar2 ,
23: p_object_id IN IEX_DEL_ASSETS.object_id%TYPE )
24: IS
25:
26: l_api_name varchar2(50) := 'Add_Rec';
27: nCount NUMBER;

Line 63: Update IEX_DEL_ASSETS

59: if p_source_module = 'IEXDLAST' then
60: FOR i IN 1..nCount
61: LOOP
62: BEGIN
63: Update IEX_DEL_ASSETS
64: SET ACTIVE_YN = 'Y'
65: where asset_id = p_id_tbl(i)
66: AND delinquency_id = p_del_id
67: AND object_id = p_object_id

Line 72: INSERT INTO IEX_DEL_ASSETS

68: AND object_code = p_object_code;
69:
70: IF sql%NOTFOUND THEN
71: BEGIN
72: INSERT INTO IEX_DEL_ASSETS
73: (DEL_ASSET_ID ,
74: LAST_UPDATE_DATE ,
75: LAST_UPDATED_BY ,
76: LAST_UPDATE_LOGIN ,

Line 86: (IEX_DEL_ASSETS_S.NEXTVAL ,

82: OBJECT_ID ,
83: ACTIVE_YN ,
84: DELINQUENCY_ID)
85: VALUES
86: (IEX_DEL_ASSETS_S.NEXTVAL ,
87: sysdate ,
88: FND_GLOBAL.USER_ID,
89: FND_GLOBAL.LOGIN_ID,
90: sysdate ,

Line 356: UPDATE IEX_DEL_ASSETS

352:
353: -- Delinquency Assets Form
354: If p_source_module = 'IEXDLAST' then
355: FORALL cnt in 1..nCount
356: UPDATE IEX_DEL_ASSETS
357: SET ACTIVE_YN = 'N'
358: WHERE DEL_ASSET_ID = p_id_tbl(cnt) ;
359:
360: Elsif p_source_module = 'IEXWOCNT' then

Line 592: UPDATE IEX_DEL_ASSETS

588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589:
590:
591: If p_source_module = 'IEXDLAST' then
592: UPDATE IEX_DEL_ASSETS
593: SET ACTIVE_YN = 'N'
594: WHERE DELINQUENCY_ID = p_del_id ;
595:
596: Elsif p_source_module = 'IEXWOCNT' then