DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on FND_DATE

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

329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
333: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
334: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
335: 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
336: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
337: 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 469: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);

465: L_MSG_OUTPUT:= ' ';
466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
467: l_msg_output:= ' ';
468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
469: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
471: L_MSG_OUTPUT:= ' ';
472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
473: --Start of 13726549