DBA Data[Home] [Help]

APPS.WIP_WIPPURGE_XMLP_PKG dependencies on WIP_DISCRETE_WS_MOVE

Line 18: WIP_DISCRETE_WS_MOVE.INITTIMEZONE;

14: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
15: /*SRW.USER_EXIT('FND FLEXSQL CODE="MSTK"
16: APPL_SHORT_NAME="INV" OUTPUT="P_FLEXDATA"
17: MODE="SELECT" DISPLAY="ALL" TABLEALIAS="MSI" ')*/NULL;
18: WIP_DISCRETE_WS_MOVE.INITTIMEZONE;
19: P_CUTOFF_DATE_CLIENT := WIP_DISCRETE_WS_MOVE.SERVERTOCLIENTDATE(P_CUTOFF_DATE);
20: P_CUTOFF_DATE_DISP := to_char(P_CUTOFF_DATE_CLIENT,DATE_FORMAT);
21: SELECT
22: WIP_DATETIMES.LE_DATE_TO_SERVER(MAX(SCHEDULE_CLOSE_DATE)

Line 19: P_CUTOFF_DATE_CLIENT := WIP_DISCRETE_WS_MOVE.SERVERTOCLIENTDATE(P_CUTOFF_DATE);

15: /*SRW.USER_EXIT('FND FLEXSQL CODE="MSTK"
16: APPL_SHORT_NAME="INV" OUTPUT="P_FLEXDATA"
17: MODE="SELECT" DISPLAY="ALL" TABLEALIAS="MSI" ')*/NULL;
18: WIP_DISCRETE_WS_MOVE.INITTIMEZONE;
19: P_CUTOFF_DATE_CLIENT := WIP_DISCRETE_WS_MOVE.SERVERTOCLIENTDATE(P_CUTOFF_DATE);
20: P_CUTOFF_DATE_DISP := to_char(P_CUTOFF_DATE_CLIENT,DATE_FORMAT);
21: SELECT
22: WIP_DATETIMES.LE_DATE_TO_SERVER(MAX(SCHEDULE_CLOSE_DATE)
23: ,P_ORGANIZATION_ID)

Line 34: ,TO_CHAR(WIP_DISCRETE_WS_MOVE.SERVERTOCLIENTDATE(P_MAX_DATE)

30: IF (P_MAX_DATE IS NULL) OR (P_CUTOFF_DATE > P_MAX_DATE) THEN
31: FND_MESSAGE.SET_NAME('WIP'
32: ,'WIP_BAD_CUTOFF_DATE');
33: FND_MESSAGE.SET_TOKEN('ENTITY'
34: ,TO_CHAR(WIP_DISCRETE_WS_MOVE.SERVERTOCLIENTDATE(P_MAX_DATE)
35: ,'DD-MON-RRRR HH24:MI:SS')
36: ,FALSE);
37: P_ERROR_TEXT := SUBSTR(FND_MESSAGE.GET
38: ,1