DBA Data[Home] [Help]

APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_QUA_AWARDS_UTIL_SS

Line 1: PACKAGE BODY hr_qua_awards_util_ss AS

1: PACKAGE BODY hr_qua_awards_util_ss AS
2: /* $Header: hrquawrs.pkb 120.1.12000000.2 2007/04/19 09:28:16 arumukhe ship $*/
3:
4:
5: -- ---------------------------------------------------------------------------

Line 1066: hr_qua_awards_util_ss.get_pending_transaction_steps

1062:
1063: BEGIN
1064:
1065: hr_utility.set_location('Entering:'||l_proc, 5);
1066: hr_qua_awards_util_ss.get_pending_transaction_steps
1067: (p_item_type => p_item_type
1068: ,p_selected_person_id => p_selected_person_id
1069: ,p_mode => p_mode
1070: ,p_process_name => p_process_name

Line 1244: hr_qua_awards_util_ss.check_errors

1240: p_qualifications(1).delete_flag = 'N')
1241: and p_save_mode <> 'SAVE_FOR_LATER'
1242: then
1243: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,35);
1244: hr_qua_awards_util_ss.check_errors
1245: (p_ignore_sub_date_boundaries => 'N'
1246: ,p_mode => p_mode
1247: ,p_qualifications => p_qualifications
1248: ,p_qua_subjects => p_qua_subjects

Line 1265: hr_qua_awards_util_ss.validate_api

1261: if (p_qualifications(1).delete_flag is null or
1262: p_qualifications(1).delete_flag = 'N') and
1263: p_save_mode <> 'SAVE_FOR_LATER' then
1264: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,40);
1265: hr_qua_awards_util_ss.validate_api
1266: (p_validate => l_validate
1267: ,p_mode => p_mode
1268: ,p_selected_person_id => p_selected_person_id
1269: ,p_qualifications => p_qualifications

Line 1279: hr_qua_awards_util_ss.save_transaction_step

1275:
1276: if l_changed = TRUE or p_qualifications(1).delete_flag = 'Y' THEN
1277:
1278: hr_utility.set_location('Delete flag = Y or changed=True'||l_proc,40);
1279: hr_qua_awards_util_ss.save_transaction_step
1280: (p_item_type => p_item_type
1281: ,p_item_key => p_item_key
1282: ,p_actid => to_number(p_act_id)
1283: ,p_transaction_step_id => l_transaction_step_id

Line 1346: hr_qua_awards_util_ss.start_transaction

1342: BEGIN
1343:
1344:
1345: hr_utility.set_location('Entering:'||l_proc, 5);
1346: hr_qua_awards_util_ss.start_transaction
1347: (itemtype => p_item_type
1348: ,itemkey => p_item_key
1349: ,actid => p_actid
1350: ,funmode => 'RUN'

Line 1365: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

1361: hr_transaction_api.create_transaction_step
1362: (p_validate => FALSE
1363: ,p_creator_person_id => p_creator_person_id
1364: ,p_transaction_id => l_transaction_id
1365: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME
1366: ,p_item_type => p_item_type
1367: ,p_item_key => p_item_key
1368: ,p_transaction_step_id => p_transaction_step_id
1369: ,p_object_version_number => l_trn_object_version_number);

Line 2373: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

2369:
2370: l_establishment := p_qua_attendance(1).establishment;
2371:
2372: --check if attendance already exists
2373: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2374:
2375: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2376: l_establishment_id := p_qua_attendance(1).establishment_id;
2377:

Line 2375: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);

2371:
2372: --check if attendance already exists
2373: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2374:
2375: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2376: l_establishment_id := p_qua_attendance(1).establishment_id;
2377:
2378: --if the school is entered (not picked from the LOV),
2379: if l_establishment_id is null then

Line 2445: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

2441: l_qualification_id := p_qualifications(1).qualification_id;
2442:
2443: if l_qualification_id is null then --a new qualification
2444: --insert attendance only for qua
2445: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2446:
2447: if l_attendance_id IS null THEN
2448:
2449: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);

Line 2451: --hr_qua_awards_util_ss.ins

2447: if l_attendance_id IS null THEN
2448:
2449: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);
2450: --attendance is not exist, then insert a new one
2451: --hr_qua_awards_util_ss.ins
2452: per_esa_ins.ins
2453: (p_validate => FALSE
2454: ,p_effective_date => sysdate
2455: ,p_attendance_id => l_attendance_id

Line 2647: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION then

2643: l_pq_object_version_number := p_qualifications(1).object_version_number;
2644: l_pea_object_version_number := p_qua_attendance(1).object_version_number;
2645:
2646: --update attendance only for qua
2647: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION then
2648: OPEN csr_school_changed(l_establishment
2649: ,p_qualifications(1).attendance_id
2650: ,p_qua_attendance(1).establishment_id);
2651: FETCH csr_school_changed INTO l_dummy;

Line 3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3123:
3124: BEGIN
3125: hr_utility.set_location('Entering:'||l_proc, 5);
3126:
3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3130: ELSE
3131: hr_utility.set_location('mode!=Education:'||l_proc,15);

Line 3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;

3125: hr_utility.set_location('Entering:'||l_proc, 5);
3126:
3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3130: ELSE
3131: hr_utility.set_location('mode!=Education:'||l_proc,15);
3132: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3133: END IF;

Line 3132: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;

3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3130: ELSE
3131: hr_utility.set_location('mode!=Education:'||l_proc,15);
3132: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3133: END IF;
3134:
3135: l_active_item_keys :=
3136: get_pending_items

Line 3138: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

3134:
3135: l_active_item_keys :=
3136: get_pending_items
3137: (p_item_type => p_item_type
3138: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME
3139: ,p_current_person_id => p_selected_person_id
3140: ,p_result_code => l_result_code
3141: );
3142:

Line 3226: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3222: hr_utility.set_location('Exception:Others'||l_proc,555);
3223: raise;
3224: END;
3225:
3226: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3227: --
3228: -- Business Rule Mapping
3229: -- =====================
3230: -- CHK_ATT_OVERLAP

Line 3275: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3271: --hr_utility.raise_error;
3272: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3273: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3274: END IF;
3275: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3276: IF p_qualifications(1).start_date is not null and
3277: p_qua_attendance(1).attended_start_date is not null and
3278: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3279: THEN

Line 4071: END hr_qua_awards_util_ss;

4067: raise;
4068: End;
4069:
4070:
4071: END hr_qua_awards_util_ss;
4072:
4073: --end of package hr_qua_awards_util_ss

Line 4073: --end of package hr_qua_awards_util_ss

4069:
4070:
4071: END hr_qua_awards_util_ss;
4072:
4073: --end of package hr_qua_awards_util_ss