DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on FND_DATE

Line 248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);

244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
250: IF L_EFF_START_DATE >= to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
251: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
252: l_date_eoy := to_date('05-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4))+1 ),'DD-MM-YYYY') ;

Line 361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);

357: L_MSG_OUTPUT:= ' ';
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
359: l_msg_output:= ' ';
360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
363: L_MSG_OUTPUT:= ' ';
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
365: --Start of 13726549