DBA Data[Home] [Help]

APPS.PAY_DK_EMP_TRAINEE_REIMBURSE dependencies on FND_DATE

Line 272: P_EFFECTIVE_DATE :=FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DATE1);

268: -- Create a temporary LOB to store the generated XML.
269: -- DBMS_LOB.CREATETEMPORARY (XMLRESULT, TRUE, DBMS_LOB.SESSION);
270: -- DBMS_LOB.CREATETEMPORARY (lv_clob, TRUE, DBMS_LOB.SESSION);
271: /*Converting the P_EFFECTIVE_DATE1 parameter to date and assigning it to P_EFFECTIVE_DATE*/
272: P_EFFECTIVE_DATE :=FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DATE1);
273: -- Control structure to identify which Quarter the report to be executed
274: IF P_QUARTER = 1 THEN
275: L_QTR_START := TO_DATE('01/01/'||TO_CHAR(P_EFFECTIVE_DATE,'YYYY'), 'DD/MM/YYYY');
276: L_QTR_END := TO_DATE('31/03/'||TO_CHAR(P_EFFECTIVE_DATE,'YYYY'), 'DD/MM/YYYY');