APPS.BOM_CSTGMSBK_XMLP_PKG dependencies on FND_DATE

Line 47: H_RPT_DATE_FROM := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM));

43: INVALID_DATE_RANGE_EXCEPT EXCEPTION;
44: BEGIN
45: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
46: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
47: H_RPT_DATE_FROM := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM));
48: H_RPT_DATE_TO := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)) + (86399 / 86400);
49: IF H_RPT_DATE_FROM > H_RPT_DATE_TO THEN
50: FND_MESSAGE.SET_NAME('FND'
51: ,'INVALID DATE RANGE');

Line 48: H_RPT_DATE_TO := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)) + (86399 / 86400);

44: BEGIN
45: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
46: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
47: H_RPT_DATE_FROM := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM));
48: H_RPT_DATE_TO := TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)) + (86399 / 86400);
49: IF H_RPT_DATE_FROM > H_RPT_DATE_TO THEN
50: FND_MESSAGE.SET_NAME('FND'
51: ,'INVALID DATE RANGE');
52: H_MSG := FND_MESSAGE.GET;

Line 77: FND_DATE.DATE_TO_CHARDT(SYSDATE)

73: ,P_ENCODED => 'F'))*/NULL;
74: END;
75: BEGIN
76: SELECT
77: FND_DATE.DATE_TO_CHARDT(SYSDATE)
78: INTO P_SYSTEM_DATE
79: FROM
80: DUAL;
81: END;

Line 84: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM)))

80: DUAL;
81: END;
82: BEGIN
83: SELECT
84: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM)))
85: INTO P_DATE_FROM_FORMATTING
86: FROM
87: DUAL;
88: END;

Line 91: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)))

87: DUAL;
88: END;
89: BEGIN
90: SELECT
91: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)))
92: INTO P_DATE_TO_FORMATTING
93: FROM
94: DUAL;
95: END;

Line 112: FND_DATE.DATE_TO_CHARDT(FCR.REQUEST_DATE),

108: END;
109: BEGIN
110: SELECT
111: FRV.RESPONSIBILITY_NAME,
112: FND_DATE.DATE_TO_CHARDT(FCR.REQUEST_DATE),
113: FAV.APPLICATION_NAME,
114: FU.USER_NAME
115: INTO CP_RESPONSIBILITY,CP_REQUEST_TIME,CP_APPLICATION,CP_REQUESTED_BY
116: FROM