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

2526: and per.establishment_id = p_school_id)
2527: and per.attendance_id <> nvl(p_attendance_id,-1)
2528: and (p_attended_start_date
2529: between per.attended_start_date
2530: and nvl(per.attended_end_date,hr_api.g_eot)
2531: or nvl(p_attended_end_date,hr_api.g_eot)
2532: between per.attended_start_date
2533: and nvl(per.attended_end_date,hr_api.g_eot))
2534: and per.attendance_id = pq.attendance_id

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

2527: and per.attendance_id <> nvl(p_attendance_id,-1)
2528: and (p_attended_start_date
2529: between per.attended_start_date
2530: and nvl(per.attended_end_date,hr_api.g_eot)
2531: or nvl(p_attended_end_date,hr_api.g_eot)
2532: between per.attended_start_date
2533: and nvl(per.attended_end_date,hr_api.g_eot))
2534: and per.attendance_id = pq.attendance_id
2535: and pq.qualification_type_id = p_qualification_type_id

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

2529: between per.attended_start_date
2530: and nvl(per.attended_end_date,hr_api.g_eot)
2531: or nvl(p_attended_end_date,hr_api.g_eot)
2532: between per.attended_start_date
2533: and nvl(per.attended_end_date,hr_api.g_eot))
2534: and per.attendance_id = pq.attendance_id
2535: and pq.qualification_type_id = p_qualification_type_id
2536: --and nvl(pq.party_id, -1) = nvl(p_party_id,-1)
2537: and nvl(pq.title,-1) = nvl(p_title,-1);

Line 2840: (p_language_code => hr_api.userenv_lang

2836: ,p_sub_information20 => p_qua_subjects(i).sub_information20
2837: );
2838:
2839: per_sbt_ins.ins_tl
2840: (p_language_code => hr_api.userenv_lang
2841: ,p_subjects_taken_id => l_subjects_taken_id
2842: ,p_grade_attained => p_qua_subjects(i).grade_attained
2843: );
2844: end if;

Line 3097: (p_language_code => hr_api.userenv_lang

3093: ,p_sub_information19 => p_qua_subjects(i).sub_information19
3094: ,p_sub_information20 => p_qua_subjects(i).sub_information20
3095: );
3096: per_sbt_ins.ins_tl
3097: (p_language_code => hr_api.userenv_lang
3098: ,p_subjects_taken_id => l_subjects_taken_id
3099: ,p_grade_attained => p_qua_subjects(i).grade_attained
3100: );
3101: ELSE

Line 3159: (p_language_code => hr_api.userenv_lang

3155: ,p_sub_information19 => p_qua_subjects(i).sub_information19
3156: ,p_sub_information20 => p_qua_subjects(i).sub_information20
3157: );
3158: per_sbt_upd.upd_tl
3159: (p_language_code => hr_api.userenv_lang
3160: ,p_subjects_taken_id => l_subjects_taken_id
3161: ,p_grade_attained => p_qua_subjects(i).grade_attained
3162: );
3163:

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

3395: and nvl(per.attendance_id,-1) = nvl(p_attendance_id,-1)
3396: and per.business_group_id +0 = p_business_group_id
3397: and per.title = p_title
3398: and per.qualification_id <> nvl(p_qualification_id,-1)
3399: and (nvl(per.start_date,hr_api.g_sot)
3400: between nvl(p_start_date,hr_api.g_sot)
3401: and nvl(p_end_date,hr_api.g_eot)
3402: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3403: between nvl(p_start_date,hr_api.g_sot)

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

3396: and per.business_group_id +0 = p_business_group_id
3397: and per.title = p_title
3398: and per.qualification_id <> nvl(p_qualification_id,-1)
3399: and (nvl(per.start_date,hr_api.g_sot)
3400: between nvl(p_start_date,hr_api.g_sot)
3401: and nvl(p_end_date,hr_api.g_eot)
3402: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3403: between nvl(p_start_date,hr_api.g_sot)
3404: and nvl(p_end_date,hr_api.g_eot));

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

3397: and per.title = p_title
3398: and per.qualification_id <> nvl(p_qualification_id,-1)
3399: and (nvl(per.start_date,hr_api.g_sot)
3400: between nvl(p_start_date,hr_api.g_sot)
3401: and nvl(p_end_date,hr_api.g_eot)
3402: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3403: between nvl(p_start_date,hr_api.g_sot)
3404: and nvl(p_end_date,hr_api.g_eot));
3405:

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

3399: and (nvl(per.start_date,hr_api.g_sot)
3400: between nvl(p_start_date,hr_api.g_sot)
3401: and nvl(p_end_date,hr_api.g_eot)
3402: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3403: between nvl(p_start_date,hr_api.g_sot)
3404: and nvl(p_end_date,hr_api.g_eot));
3405:
3406: l_date_test date;
3407: l_pea_start_date date;

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

3400: between nvl(p_start_date,hr_api.g_sot)
3401: and nvl(p_end_date,hr_api.g_eot)
3402: or nvl(per.end_date,nvl(per.start_date,p_start_date))
3403: between nvl(p_start_date,hr_api.g_sot)
3404: and nvl(p_end_date,hr_api.g_eot));
3405:
3406: l_date_test date;
3407: l_pea_start_date date;
3408: l_pea_end_date date;

Line 4229: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;

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

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