APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_API_TRANSACTION_STEPS

Line 941: from hr_api_transaction_steps

937: ,p_creator_person_id in number) is
938:
939: cursor c_get_transaction_step_id(p_transaction_id number) is
940: select transaction_step_id
941: from hr_api_transaction_steps
942: where transaction_id = p_transaction_id;
943:
944: l_transaction_id hr_api_transactions.transaction_id%type;
945: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

Line 945: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

941: from hr_api_transaction_steps
942: where transaction_id = p_transaction_id;
943:
944: l_transaction_id hr_api_transactions.transaction_id%type;
945: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
946: l_proc varchar2(72) := g_package||'delete_transaction_step';
947:
948: begin
949:

Line 1338: l_trn_object_version_number hr_api_transaction_steps.object_version_number%TYPE;

1334: ,p_proc_call in varchar2 ) IS
1335:
1336: l_result VARCHAR2(100);
1337: l_transaction_id number;
1338: l_trn_object_version_number hr_api_transaction_steps.object_version_number%TYPE;
1339: l_subject_count number;
1340: l_proc varchar2(72) := g_package||'save_transaction_step';
1341:
1342: BEGIN

Line 2991: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

2987: -- declare local variables
2988: -- --------------------------------------------------------------------------
2989: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
2990: l_transaction_id hr_api_transactions.transaction_id%type;
2991: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
2992: l_proc varchar2(72) := g_package||'start_transaction';
2993:
2994: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
2995:

Line 3001: hr_api_transaction_steps

2997: is
2998: select
2999: transaction_step_id
3000: from
3001: hr_api_transaction_steps
3002: where
3003: transaction_id = l_transaction_id;
3004:
3005: Begin

Line 3075: from hr_api_transactions t, hr_api_transaction_steps ts

3071:
3072: -- Local cursor definitions
3073: cursor csr_pending_items is
3074: select transaction_step_id, activity_id, t.item_key
3075: from hr_api_transactions t, hr_api_transaction_steps ts
3076: ,wf_item_activity_statuses s
3077: where t.selected_person_id = p_current_person_id
3078: and t.status = 'Y'
3079: and t.item_type = p_item_type

Line 3117: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

3113: ,p_transaction_step_id out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
3114:
3115: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3116: l_pending_count number;
3117: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3118: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3119: l_is_workflow_complete varchar2(1) := 'N';
3120: j number := 1;
3121: l_result_code varchar2(30);

Line 3118: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

3114:
3115: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3116: l_pending_count number;
3117: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3118: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3119: l_is_workflow_complete varchar2(1) := 'N';
3120: j number := 1;
3121: l_result_code varchar2(30);
3122: l_proc varchar2(72) := g_package||'get_pending_transaction_steps';

Line 4017: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;

4013:
4014: Begin
4015: hr_utility.set_location('Entering:'||l_proc, 5);
4016: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4017: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4018: hr_utility.set_location('Exiting:'||l_proc, 15);
4019:
4020: Exception
4021: when others then