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.7 2010/05/31 11:29:37 kkolli ship $*/
3:
4:
5: -- ---------------------------------------------------------------------------

Line 1264: hr_qua_awards_util_ss.get_pending_transaction_steps

1260:
1261: BEGIN
1262:
1263: hr_utility.set_location('Entering:'||l_proc, 5);
1264: hr_qua_awards_util_ss.get_pending_transaction_steps
1265: (p_item_type => p_item_type
1266: ,p_selected_person_id => p_selected_person_id
1267: ,p_mode => p_mode
1268: ,p_process_name => p_process_name

Line 1442: hr_qua_awards_util_ss.check_errors

1438: p_qualifications(1).delete_flag = 'N')
1439: and p_save_mode <> 'SAVE_FOR_LATER'
1440: then
1441: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,35);
1442: hr_qua_awards_util_ss.check_errors
1443: (p_ignore_sub_date_boundaries => 'N'
1444: ,p_mode => p_mode
1445: ,p_qualifications => p_qualifications
1446: ,p_qua_subjects => p_qua_subjects

Line 1463: hr_qua_awards_util_ss.validate_api

1459: if (p_qualifications(1).delete_flag is null or
1460: p_qualifications(1).delete_flag = 'N') and
1461: p_save_mode <> 'SAVE_FOR_LATER' then
1462: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,40);
1463: hr_qua_awards_util_ss.validate_api
1464: (p_validate => l_validate
1465: ,p_mode => p_mode
1466: ,p_selected_person_id => p_selected_person_id
1467: ,p_qualifications => p_qualifications

Line 1477: hr_qua_awards_util_ss.save_transaction_step

1473:
1474: if l_changed = TRUE or p_qualifications(1).delete_flag = 'Y' THEN
1475:
1476: hr_utility.set_location('Delete flag = Y or changed=True'||l_proc,40);
1477: hr_qua_awards_util_ss.save_transaction_step
1478: (p_item_type => p_item_type
1479: ,p_item_key => p_item_key
1480: ,p_actid => to_number(p_act_id)
1481: ,p_transaction_step_id => l_transaction_step_id

Line 1544: hr_qua_awards_util_ss.start_transaction

1540: BEGIN
1541:
1542:
1543: hr_utility.set_location('Entering:'||l_proc, 5);
1544: hr_qua_awards_util_ss.start_transaction
1545: (itemtype => p_item_type
1546: ,itemkey => p_item_key
1547: ,actid => p_actid
1548: ,funmode => 'RUN'

Line 1563: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

1559: hr_transaction_api.create_transaction_step
1560: (p_validate => FALSE
1561: ,p_creator_person_id => p_creator_person_id
1562: ,p_transaction_id => l_transaction_id
1563: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME
1564: ,p_item_type => p_item_type
1565: ,p_item_key => p_item_key
1566: ,p_transaction_step_id => p_transaction_step_id
1567: ,p_object_version_number => l_trn_object_version_number);

Line 2579: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

2575:
2576: l_establishment := p_qua_attendance(1).establishment;
2577:
2578: --check if attendance already exists
2579: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2580:
2581: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2582: l_establishment_id := p_qua_attendance(1).establishment_id;
2583:

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

2577:
2578: --check if attendance already exists
2579: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2580:
2581: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2582: l_establishment_id := p_qua_attendance(1).establishment_id;
2583:
2584: --if the school is entered (not picked from the LOV),
2585: if l_establishment_id is null then

Line 2651: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

2647: l_qualification_id := p_qualifications(1).qualification_id;
2648:
2649: if l_qualification_id is null then --a new qualification
2650: --insert attendance only for qua
2651: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2652:
2653: if l_attendance_id IS null THEN
2654:
2655: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);

Line 2657: --hr_qua_awards_util_ss.ins

2653: if l_attendance_id IS null THEN
2654:
2655: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);
2656: --attendance is not exist, then insert a new one
2657: --hr_qua_awards_util_ss.ins
2658: per_esa_ins.ins
2659: (p_validate => FALSE
2660: ,p_effective_date => sysdate
2661: ,p_attendance_id => l_attendance_id

Line 2853: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION then

2849: l_pq_object_version_number := p_qualifications(1).object_version_number;
2850: l_pea_object_version_number := p_qua_attendance(1).object_version_number;
2851:
2852: --update attendance only for qua
2853: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION then
2854: OPEN csr_school_changed(l_establishment
2855: ,p_qualifications(1).attendance_id
2856: ,p_qua_attendance(1).establishment_id);
2857: FETCH csr_school_changed INTO l_dummy;

Line 3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3336:
3337: BEGIN
3338: hr_utility.set_location('Entering:'||l_proc, 5);
3339:
3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3343: ELSE
3344: hr_utility.set_location('mode!=Education:'||l_proc,15);

Line 3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;

3338: hr_utility.set_location('Entering:'||l_proc, 5);
3339:
3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3343: ELSE
3344: hr_utility.set_location('mode!=Education:'||l_proc,15);
3345: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3346: END IF;

Line 3345: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;

3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3343: ELSE
3344: hr_utility.set_location('mode!=Education:'||l_proc,15);
3345: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3346: END IF;
3347:
3348: l_active_item_keys :=
3349: get_pending_items

Line 3351: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

3347:
3348: l_active_item_keys :=
3349: get_pending_items
3350: (p_item_type => p_item_type
3351: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME
3352: ,p_current_person_id => p_selected_person_id
3353: ,p_result_code => l_result_code
3354: );
3355:

Line 3439: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3435: hr_utility.set_location('Exception:Others'||l_proc,555);
3436: raise;
3437: END;
3438:
3439: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3440: --
3441: -- Business Rule Mapping
3442: -- =====================
3443: -- CHK_ATT_OVERLAP

Line 3488: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

3484: --hr_utility.raise_error;
3485: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3486: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3487: END IF;
3488: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3489: IF p_qualifications(1).start_date is not null and
3490: p_qua_attendance(1).attended_start_date is not null and
3491: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3492: THEN

Line 4284: END hr_qua_awards_util_ss;

4280: raise;
4281: End;
4282:
4283:
4284: END hr_qua_awards_util_ss;
4285:
4286: --end of package hr_qua_awards_util_ss

Line 4286: --end of package hr_qua_awards_util_ss

4282:
4283:
4284: END hr_qua_awards_util_ss;
4285:
4286: --end of package hr_qua_awards_util_ss