APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_API_TRANSACTIONS

Line 1142: l_transaction_id hr_api_transactions.transaction_id%type;

1138: select transaction_step_id
1139: from hr_api_transaction_steps
1140: where transaction_id = p_transaction_id;
1141:
1142: l_transaction_id hr_api_transactions.transaction_id%type;
1143: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1144: l_proc varchar2(72) := g_package||'delete_transaction_step';
1145:
1146: begin

Line 3202: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

3198: ,result out nocopy varchar2) is
3199: -- --------------------------------------------------------------------------
3200: -- declare local variables
3201: -- --------------------------------------------------------------------------
3202: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
3203: l_transaction_id hr_api_transactions.transaction_id%type;
3204: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3205: l_proc varchar2(72) := g_package||'start_transaction';
3206:

Line 3203: l_transaction_id hr_api_transactions.transaction_id%type;

3199: -- --------------------------------------------------------------------------
3200: -- declare local variables
3201: -- --------------------------------------------------------------------------
3202: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
3203: l_transaction_id hr_api_transactions.transaction_id%type;
3204: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3205: l_proc varchar2(72) := g_package||'start_transaction';
3206:
3207: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

Line 3207: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

3203: l_transaction_id hr_api_transactions.transaction_id%type;
3204: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3205: l_proc varchar2(72) := g_package||'start_transaction';
3206:
3207: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
3208:
3209: Cursor c_get_transaction_step_id
3210: is
3211: select

Line 3288: from hr_api_transactions t, hr_api_transaction_steps ts

3284:
3285: -- Local cursor definitions
3286: cursor csr_pending_items is
3287: select transaction_step_id, activity_id, t.item_key
3288: from hr_api_transactions t, hr_api_transaction_steps ts
3289: ,wf_item_activity_statuses s
3290: where t.selected_person_id = p_current_person_id
3291: and t.status = 'Y'
3292: and t.item_type = p_item_type