APPS.IEX_DEL_SUB_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 63

                    Update IEX_DEL_ASSETS
                        SET ACTIVE_YN      = 'Y'
                        where asset_id     = p_id_tbl(i)
                        AND delinquency_id = p_del_id
                        AND object_id      = p_object_id
                        AND object_code    = p_object_code;

Line: 72

                          INSERT INTO IEX_DEL_ASSETS
                           (DEL_ASSET_ID          ,
                            LAST_UPDATE_DATE      ,
                            LAST_UPDATED_BY       ,
                            LAST_UPDATE_LOGIN     ,
                            CREATION_DATE         ,
                            CREATED_BY            ,
                            OBJECT_VERSION_NUMBER ,
                            ASSET_ID              ,
                            OBJECT_CODE           ,
                            OBJECT_ID             ,
                            ACTIVE_YN             ,
                            DELINQUENCY_ID)
                          VALUES
                           (IEX_DEL_ASSETS_S.NEXTVAL    ,
                            sysdate     ,
                            FND_GLOBAL.USER_ID,
                            FND_GLOBAL.LOGIN_ID,
                            sysdate     ,
                            FND_GLOBAL.USER_ID,
                            1     ,
                            p_id_tbl(i),
                            p_object_code   ,
                            p_object_id ,
                            'Y'     ,
                            p_del_id);

Line: 105

						('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
							'  || SQLCODE || ' >> ' || SQLERRM);

Line: 119

					('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - UPDATE >>
						'  || SQLCODE || ' >> ' || SQLERRM);

Line: 131

                    Update IEX_WRITEOFF_CONTRACTS
                    SET ACTIVE_YN      = 'Y'
                    where contract_id  = p_id_tbl(i)
                    AND delinquency_id = p_del_id
                    AND object_id      = p_object_id
                    AND object_code    = p_object_code;

Line: 141

                          INSERT INTO IEX_WRITEOFF_CONTRACTS
                           (WRITEOFF_CONTRACT_ID  ,
                            LAST_UPDATE_DATE      ,
                            LAST_UPDATED_BY       ,
                            LAST_UPDATE_LOGIN     ,
                            CREATION_DATE         ,
                            CREATED_BY            ,
                            OBJECT_VERSION_NUMBER ,
                            CONTRACT_ID           ,
                            OBJECT_CODE           ,
                            OBJECT_ID             ,
                            ACTIVE_YN             ,
                            DELINQUENCY_ID)
                          VALUES
                           (IEX_WRITEOFF_CONTRACTS_S.NEXTVAL,
                            sysdate     ,
                            FND_GLOBAL.USER_ID,
                            FND_GLOBAL.LOGIN_ID,
                            sysdate     ,
                            FND_GLOBAL.USER_ID,
                            1     ,
                            p_id_tbl(i),
                            p_object_code   ,
                            p_object_id ,
                            'Y'     ,
                            p_del_id);

Line: 173

						('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
							'  || SQLCODE || ' >> ' || SQLERRM);

Line: 186

					('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - UPDATE >>
							'  || SQLCODE || ' >> ' || SQLERRM);

Line: 199

                    Update IEX_WRITEOFF_INVOICES
                    SET ACTIVE_YN            = 'Y'
                    where lease_inv_line_id  = p_id_tbl(i)
                    AND delinquency_id       = p_del_id
                    AND object_id            = p_object_id
                    AND object_code          = p_object_code;

Line: 209

                        INSERT INTO IEX_WRITEOFF_INVOICES
                           (WRITEOFF_INVOICE_ID   ,
                            LAST_UPDATE_DATE      ,
                            LAST_UPDATED_BY       ,
                            LAST_UPDATE_LOGIN     ,
                            CREATION_DATE         ,
                            CREATED_BY            ,
                            OBJECT_VERSION_NUMBER ,
                            LEASE_INV_LINE_ID     ,
                            OBJECT_CODE           ,
                            OBJECT_ID             ,
                            ACTIVE_YN             ,
                            DELINQUENCY_ID)
                        VALUES
                           (IEX_WRITEOFF_INVOICES_S.NEXTVAL,
                            sysdate,
                            FND_GLOBAL.USER_ID,
                            FND_GLOBAL.LOGIN_ID,
                            sysdate,
                            FND_GLOBAL.USER_ID,
                            1,
                            p_id_tbl(i),
                            p_object_code,
                            p_object_id,
                            'Y',
                            p_del_id);

Line: 241

						('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
							'  || SQLCODE || ' >> ' || SQLERRM);

Line: 255

					('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
						'  || SQLCODE || ' >> ' || SQLERRM);

Line: 356

	   	 UPDATE IEX_DEL_ASSETS
	    	SET ACTIVE_YN = 'N'
	    	WHERE DEL_ASSET_ID = p_id_tbl(cnt) ;

Line: 362

	   	UPDATE IEX_WRITEOFF_CONTRACTS
	    	SET ACTIVE_YN = 'N'
	    	WHERE WRITEOFF_CONTRACT_ID = p_id_tbl(cnt) ;

Line: 368

	   	UPDATE IEX_WRITEOFF_INVOICES
	    	SET ACTIVE_YN = 'N'
	    	WHERE WRITEOFF_INVOICE_ID = p_id_tbl(cnt) ;

Line: 470

	   select asset_id
	   	BULK COLLECT INTO v_id_tbl
	   from iex_available_assets_v  ;

Line: 477

	   -- Select id from Left Side Bali Spread for WriteOff Contract
	   --select contract_id
	   --	BULK COLLECT INTO v_id_tbl
	   --from iex_available_assets_v
	   --where delinquency_id = p_del_id ;

Line: 484

	   -- Select id from Left Side Bali Spread for WriteOff Invoice
	   --select asset_id
	   --	BULK COLLECT INTO v_id_tbl
	   --from iex_available_assets_v
	   --where delinquency_id = p_del_id ;

Line: 592

	    UPDATE IEX_DEL_ASSETS
	    	SET ACTIVE_YN = 'N'
	    WHERE DELINQUENCY_ID = p_del_id ;

Line: 597

	    UPDATE IEX_WRITEOFF_CONTRACTS
	    	SET ACTIVE_YN = 'N'
	    WHERE DELINQUENCY_ID = p_del_id ;

Line: 602

	    UPDATE IEX_WRITEOFF_INVOICES
	    	SET ACTIVE_YN = 'N'
	    WHERE DELINQUENCY_ID = p_del_id ;

Line: 693

        SELECT  b.user_id, b.user_name
        FROM    JTF_RS_RESOURCE_EXTNS a ,
                JTF_RS_RESOURCE_EXTNS b
        WHERE   b.source_id = a.source_mgr_id
        AND     a.user_id = p_user_id ;

Line: 701

        SELECT  user_name
        FROM    JTF_RS_RESOURCE_EXTNS
        WHERE   user_id = p_user_id ;

Line: 761

	select IEX_DEL_WF_S.NEXTVAL
	Into Itemkey
	from dual ;