APPS.WIP_CLOSE_UTILITIES SQL Statements

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

Line: 10

        SELECT  WDJ.DATE_RELEASED,
                WDJ.DATE_COMPLETED,
                WDJ.DATE_CLOSED
        FROM    ORG_ACCT_PERIODS OAP,
                WIP_DISCRETE_JOBS WDJ
        WHERE   WDJ.WIP_ENTITY_ID = P_Wip_Entity_Id
        AND     WDJ.ORGANIZATION_ID = P_Organization_Id
        AND     OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
        AND     INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,
                                                       wdj.organization_id)
                  BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE
        AND     OAP.OPEN_FLAG = 'Y';

Line: 39

        WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES
		(P_wip_entity_id, P_organization_id, '', '',
                              P_class_code, X_Date_closed);

Line: 46

    UPDATE WIP_ENTITIES
       SET ENTITY_TYPE = decode(ENTITY_TYPE, 7, 6, 8, 5, 1)
     WHERE WIP_ENTITY_ID = P_wip_entity_id;

Line: 81

                        SELECT WDCT.STATUS_TYPE,
			       WDCT.rowid
                        FROM   WIP_DISCRETE_JOBS WDJ,
			       WIP_DJ_CLOSE_TEMP WDCT
                        WHERE  WDCT.WIP_ENTITY_ID = P_wip_entity_id
                        AND    WDCT.ORGANIZATION_ID = P_organization_id
			AND    WDJ.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID
			AND    WDJ.STATUS_TYPE = WIP_CONSTANTS.PEND_CLOSE;

Line: 100

                        DELETE FROM WIP_DJ_CLOSE_TEMP
                        WHERE ROWID = rid;