DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_SS dependencies on PAY_COST_ALLOCATIONS_F

Line 356: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;

352: l_effective_date date;
353: l_effective_start_date date;
354: l_effective_end_date date;
355: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
356: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
357: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
358: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
359: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
360:

Line 358: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;

354: l_effective_end_date date;
355: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
356: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
357: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
358: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
359: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
360:
361: BEGIN
362: IF g_debug THEN

Line 884: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;

880: l_effective_date date;
881: l_effective_start_date date default null;
882: l_effective_end_date date default null;
883: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
884: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
885: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
886: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
887: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
888: l_update_datetrack_mode VARCHAR2(20);

Line 886: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;

882: l_effective_end_date date default null;
883: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
884: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
885: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
886: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
887: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
888: l_update_datetrack_mode VARCHAR2(20);
889: BEGIN
890:

Line 1212: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;

1208: l_proc varchar2(100) := g_package||'DELETE_DATA';
1209: l_effective_date date;
1210: l_effective_start_date date;
1211: l_effective_end_date date;
1212: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
1213: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
1214: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
1215: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
1216: l_datetrack_delete_mode VARCHAR2(20);

Line 1214: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;

1210: l_effective_start_date date;
1211: l_effective_end_date date;
1212: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
1213: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
1214: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
1215: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
1216: l_datetrack_delete_mode VARCHAR2(20);
1217:
1218: BEGIN