DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_SS dependencies on HR_API_TRANSACTIONS

Line 55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

51: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
52: ) is
53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;

Line 359: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

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
363: hr_utility.set_location('Entering '||l_proc,10);

Line 580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

576: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
577: ) as
578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;

Line 887: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

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:
891: if g_debug then

Line 1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

1071: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
1072: ) is
1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;

Line 1215: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

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
1219: IF g_debug THEN