[Home] [Help]
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: if p_transaction_step_id is null then
714:
715: hr_utility.set_location('if p_transaction_step_id is null then:'||l_proc,10);
716: hr_assignment_common_save_web.get_step
717: (p_item_type => p_item_type
718: ,p_item_key => p_item_key
719: ,p_api_name => g_api_name
720: ,p_transaction_step_id => l_transaction_step_id
2582: open csr_get_prim_asg;
2583: fetch csr_get_prim_asg into l_db_assignment_rec;
2584: close csr_get_prim_asg;
2585: else
2586: hr_assignment_common_save_web.get_asg_from_asg
2587: (p_assignment_id => l_assignment_id
2588: ,p_effective_date => l_effective_date
2589: ,p_assignment_rec => l_db_assignment_rec);
2590: end if;
2592: -- look to see if we have already a transaction step in progress
2593: -- this check is based on the api_name and not the activity_id because
2594: -- each step will have a different activity_id.
2595: --
2596: hr_assignment_common_save_web.get_step
2597: (p_item_type => l_item_type
2598: ,p_item_key => l_item_key
2599: ,p_api_name => g_api_name
2600: ,p_transaction_step_id => l_transaction_step_id
5813: -- then remove the existing PayRate Transaction if any with
5814: -- activityId = -1
5815:
5816: -- Need to see if an asg txn step id exists or not.
5817: hr_assignment_common_save_web.get_step
5818: (p_item_type => p_item_type
5819: ,p_item_key => p_item_key
5820: ,p_api_name => 'PER_SSHR_CHANGE_PAY.PROCESS_API'
5821: ,p_transaction_step_id => ln_gsp_step_id
5821: ,p_transaction_step_id => ln_gsp_step_id
5822: ,p_transaction_id => l_transaction_id);
5823:
5824: if (ln_gsp_step_id is null) then
5825: hr_assignment_common_save_web.get_step
5826: (p_item_type => p_item_type
5827: ,p_item_key => p_item_key
5828: ,p_api_name => 'HR_PAY_RATE_SS.PROCESS_API'
5829: ,p_transaction_step_id => ln_gsp_step_id
5862: END IF;
5863: -- GSP Change
5864: -- delete the existing PayRate Transaction if any
5865: -- Need to see if an asg txn step id exists or not.
5866: hr_assignment_common_save_web.get_step
5867: (p_item_type => p_item_type
5868: ,p_item_key => p_item_key
5869: ,p_api_name => 'PER_SSHR_CHANGE_PAY.PROCESS_API'
5870: ,p_transaction_step_id => ln_gsp_step_id
5870: ,p_transaction_step_id => ln_gsp_step_id
5871: ,p_transaction_id => l_transaction_id);
5872:
5873: if (ln_gsp_step_id is null) then
5874: hr_assignment_common_save_web.get_step
5875: (p_item_type => p_item_type
5876: ,p_item_key => p_item_key
5877: ,p_api_name => 'HR_PAY_RATE_SS.PROCESS_API'
5878: ,p_transaction_step_id => ln_gsp_step_id