APPS.HR_NEW_USER_REG_SS dependencies on HR_API_TRANSACTIONS

Line 56: select status from hr_api_transactions hrt

52: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
53:
54: --Added for the Bug 14158934
55: cursor csr_txn_status is
56: select status from hr_api_transactions hrt
57: where hrt.transaction_id = hr_transaction_ss.get_transaction_id(WfItemType ,WfItemKey);
58:
59: l_effective_date date;
60: l_session_c number;

Line 178: l_transaction_id hr_api_transactions.transaction_id%type;

174: ,p_source in varchar2 default null) is
175: -- --------------------------------------------------------------------------
176: -- declare local variables
177: -- --------------------------------------------------------------------------
178: l_transaction_id hr_api_transactions.transaction_id%type;
179: l_application_error boolean := false;
180: l_object_version_error boolean := false;
181: l_obj_fatal_error boolean := false;
182: l_warning_error boolean := false;

Line 447: l_transaction_id hr_api_transactions.transaction_id%type;

443: l_assignment_sequence number;
444: l_assignment_number varchar2(250);
445: l_assign_payroll_warning boolean;
446: l_proc varchar2(72) := g_package||'processExEmpTransaction';
447: l_transaction_id hr_api_transactions.transaction_id%type;
448: l_date Date;
449: begin
450: hr_utility.set_location('Entering:'|| l_proc, 5);
451: l_person_id := PersonId;