APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HR_UTILITY

Line 777: hr_utility.trace(' sql: '||l_pa_sql);

773: END IF;
774:
775:
776: -- Bug 12605349
777: hr_utility.trace(' sql: '||l_pa_sql);
778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql

Line 778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));

774:
775:
776: -- Bug 12605349
777: hr_utility.trace(' sql: '||l_pa_sql);
778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),

Line 779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));

775:
776: -- Bug 12605349
777: hr_utility.trace(' sql: '||l_pa_sql);
778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

Line 794: hr_utility.trace(' l_pa_cursor count: '||l_pa_cursor%rowcount);

790: dettab,
791: ovntab,ludtab LIMIT 500;
792:
793: -- Bug 12605349
794: hr_utility.trace(' l_pa_cursor count: '||l_pa_cursor%rowcount);
795:
796:
797: EXIT WHEN restab.COUNT = 0;
798: