eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_API

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 944: l_transaction_id hr_api_transactions.transaction_id%type;

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;
946: l_proc varchar2(72) := g_package||'delete_transaction_step';
947:
948: begin

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 2326: and nvl(per.attended_end_date,hr_api.g_eot)

2322: and per.establishment_id = p_school_id)
2323: and per.attendance_id <> nvl(p_attendance_id,-1)
2324: and (p_attended_start_date
2325: between per.attended_start_date
2326: and nvl(per.attended_end_date,hr_api.g_eot)
2327: or nvl(p_attended_end_date,hr_api.g_eot)
2328: between per.attended_start_date
2329: and nvl(per.attended_end_date,hr_api.g_eot))
2330: and per.attendance_id = pq.attendance_id

Line 2327: or nvl(p_attended_end_date,hr_api.g_eot)

2323: and per.attendance_id <> nvl(p_attendance_id,-1)
2324: and (p_attended_start_date
2325: between per.attended_start_date
2326: and nvl(per.attended_end_date,hr_api.g_eot)
2327: or nvl(p_attended_end_date,hr_api.g_eot)
2328: between per.attended_start_date
2329: and nvl(per.attended_end_date,hr_api.g_eot))
2330: and per.attendance_id = pq.attendance_id
2331: and pq.qualification_type_id = p_qualification_type_id

Line 2329: and nvl(per.attended_end_date,hr_api.g_eot))

2325: between per.attended_start_date
2326: and nvl(per.attended_end_date,hr_api.g_eot)
2327: or nvl(p_attended_end_date,hr_api.g_eot)
2328: between per.attended_start_date
2329: and nvl(per.attended_end_date,hr_api.g_eot))
2330: and per.attendance_id = pq.attendance_id
2331: and pq.qualification_type_id = p_qualification_type_id
2332: --and nvl(pq.party_id, -1) = nvl(p_party_id,-1)
2333: and nvl(pq.title,-1) = nvl(p_title,-1);

Line 2634: (p_language_code => hr_api.userenv_lang

2630: ,p_sub_information20 => p_qua_subjects(i).sub_information20
2631: );
2632:
2633: per_sbt_ins.ins_tl
2634: (p_language_code => hr_api.userenv_lang
2635: ,p_subjects_taken_id => l_subjects_taken_id
2636: ,p_grade_attained => p_qua_subjects(i).grade_attained
2637: );
2638: end if;

Line 2884: (p_language_code => hr_api.userenv_lang

2880: ,p_sub_information19 => p_qua_subjects(i).sub_information19
2881: ,p_sub_information20 => p_qua_subjects(i).sub_information20
2882: );
2883: per_sbt_ins.ins_tl
2884: (p_language_code => hr_api.userenv_lang
2885: ,p_subjects_taken_id => l_subjects_taken_id
2886: ,p_grade_attained => p_qua_subjects(i).grade_attained
2887: );
2888: ELSE

Line 2946: (p_language_code => hr_api.userenv_lang

2942: ,p_sub_information19 => p_qua_subjects(i).sub_information19
2943: ,p_sub_information20 => p_qua_subjects(i).sub_information20
2944: );
2945: per_sbt_upd.upd_tl
2946: (p_language_code => hr_api.userenv_lang
2947: ,p_subjects_taken_id => l_subjects_taken_id
2948: ,p_grade_attained => p_qua_subjects(i).grade_attained
2949: );
2950:

Line 2989: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

2985: ,result out nocopy varchar2) is
2986: -- --------------------------------------------------------------------------
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:

Line 2990: l_transaction_id hr_api_transactions.transaction_id%type;

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

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 2994: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

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:
2996: Cursor c_get_transaction_step_id
2997: is
2998: select

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 3186: and (nvl(per.start_date,hr_api.g_sot)

3182: and nvl(per.attendance_id,-1) = nvl(p_attendance_id,-1)
3183: and per.business_group_id +0 = p_business_group_id
3184: and per.title = p_title
3185: and per.qualification_id <> nvl(p_qualification_id,-1)
3186: and (nvl(per.start_date,hr_api.g_sot)
3187: between nvl(p_start_date,hr_api.g_sot)
3188: and nvl(p_end_date,hr_api.g_eot)
3189: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3190: between nvl(p_start_date,hr_api.g_sot)

Line 3187: between nvl(p_start_date,hr_api.g_sot)

3183: and per.business_group_id +0 = p_business_group_id
3184: and per.title = p_title
3185: and per.qualification_id <> nvl(p_qualification_id,-1)
3186: and (nvl(per.start_date,hr_api.g_sot)
3187: between nvl(p_start_date,hr_api.g_sot)
3188: and nvl(p_end_date,hr_api.g_eot)
3189: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3190: between nvl(p_start_date,hr_api.g_sot)
3191: and nvl(p_end_date,hr_api.g_eot));

Line 3188: and nvl(p_end_date,hr_api.g_eot)

3184: and per.title = p_title
3185: and per.qualification_id <> nvl(p_qualification_id,-1)
3186: and (nvl(per.start_date,hr_api.g_sot)
3187: between nvl(p_start_date,hr_api.g_sot)
3188: and nvl(p_end_date,hr_api.g_eot)
3189: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3190: between nvl(p_start_date,hr_api.g_sot)
3191: and nvl(p_end_date,hr_api.g_eot));
3192:

Line 3190: between nvl(p_start_date,hr_api.g_sot)

3186: and (nvl(per.start_date,hr_api.g_sot)
3187: between nvl(p_start_date,hr_api.g_sot)
3188: and nvl(p_end_date,hr_api.g_eot)
3189: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3190: between nvl(p_start_date,hr_api.g_sot)
3191: and nvl(p_end_date,hr_api.g_eot));
3192:
3193: l_date_test date;
3194: l_pea_start_date date;

Line 3191: and nvl(p_end_date,hr_api.g_eot));

3187: between nvl(p_start_date,hr_api.g_sot)
3188: and nvl(p_end_date,hr_api.g_eot)
3189: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3190: between nvl(p_start_date,hr_api.g_sot)
3191: and nvl(p_end_date,hr_api.g_eot));
3192:
3193: l_date_test date;
3194: l_pea_start_date date;
3195: l_pea_end_date date;

Line 4016: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;

4012: l_proc varchar2(72) := g_package||'rollback_transaction_step';
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

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