APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_API_TRANSACTION_STEPS

Line 1139: from hr_api_transaction_steps

1135: ,p_creator_person_id in number) is
1136:
1137: cursor c_get_transaction_step_id(p_transaction_id number) is
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;

Line 1143: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

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
1147:

Line 1536: l_trn_object_version_number hr_api_transaction_steps.object_version_number%TYPE;

1532: ,p_proc_call in varchar2 ) IS
1533:
1534: l_result VARCHAR2(100);
1535: l_transaction_id number;
1536: l_trn_object_version_number hr_api_transaction_steps.object_version_number%TYPE;
1537: l_subject_count number;
1538: l_proc varchar2(72) := g_package||'save_transaction_step';
1539:
1540: BEGIN

Line 3204: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

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;
3208:

Line 3214: hr_api_transaction_steps

3210: is
3211: select
3212: transaction_step_id
3213: from
3214: hr_api_transaction_steps
3215: where
3216: transaction_id = l_transaction_id;
3217:
3218: Begin

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

Line 3330: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

3326: ,p_transaction_step_id out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
3327:
3328: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3329: l_pending_count number;
3330: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3331: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3332: l_is_workflow_complete varchar2(1) := 'N';
3333: j number := 1;
3334: l_result_code varchar2(30);

Line 3331: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

3327:
3328: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3329: l_pending_count number;
3330: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3331: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3332: l_is_workflow_complete varchar2(1) := 'N';
3333: j number := 1;
3334: l_result_code varchar2(30);
3335: l_proc varchar2(72) := g_package||'get_pending_transaction_steps';

Line 4230: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;

4226:
4227: Begin
4228: hr_utility.set_location('Entering:'||l_proc, 5);
4229: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4230: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4231: hr_utility.set_location('Exiting:'||l_proc, 15);
4232:
4233: Exception
4234: when others then