APPS.HR_QUA_AWARDS_UTIL_SS dependencies on SSHR_QUA_SUBJECT_TAB_TYP

Line 18: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

14: ,p_qualification_id in varchar2
15: ,p_pq_object_version_number in varchar2
16: ,p_attendance_id in varchar2
17: ,p_pea_object_version_number in varchar2
18: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
19: ) IS
20: --Bug#3236273
21:
22: cursor subjects_for_qua(p_qualification_id in varchar2)is

Line 116: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;

112:
113: l_mode varchar2(2000);
114:
115: l_qualifications SSHR_QUA_TAB_TYP;
116: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;
117: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;
118: l_selected_person_id number;
119: l_proc varchar2(72) := g_package||'process_api';
120:

Line 392: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

388: -- is_entire_qua_changed
389: -- ---------------------------------------------------------------------------
390: FUNCTION is_entire_qua_changed
391: (p_qualifications in SSHR_QUA_TAB_TYP
392: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
393: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
394: )
395:
396: RETURN BOOLEAN IS

Line 1256: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;

1252:
1253: l_mode varchar2(2000);
1254:
1255: l_qualifications SSHR_QUA_TAB_TYP;
1256: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;
1257: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;
1258: l_selected_person_id number;
1259: l_proc varchar2(72) := g_package||'get_pending_transaction_ids';
1260:

Line 1394: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

1390: ,p_proc_call in varchar2
1391: ,p_error_message in out nocopy varchar2
1392: ,p_subjects_error_message in out nocopy varchar2
1393: ,p_qualifications in SSHR_QUA_TAB_TYP
1394: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
1395: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP) is
1396:
1397: l_app_exception exception;
1398:

Line 1530: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

1526: ,p_mode in varchar2
1527: ,p_creator_person_id in number
1528: ,p_selected_person_id in number
1529: ,p_qualifications in SSHR_QUA_TAB_TYP
1530: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
1531: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
1532: ,p_proc_call in varchar2 ) IS
1533:
1534: l_result VARCHAR2(100);

Line 2457: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

2453: (p_validate in boolean
2454: ,p_mode in varchar2
2455: ,p_selected_person_id in number
2456: ,p_qualifications in SSHR_QUA_TAB_TYP
2457: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
2458: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
2459: ) IS
2460: CURSOR csr_school_changed(p_establishment in varchar2
2461: ,p_attendance_id in number

Line 3377: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

3373: PROCEDURE check_errors
3374: (p_ignore_sub_date_boundaries in varchar2
3375: ,p_mode in varchar2
3376: ,p_qualifications in SSHR_QUA_TAB_TYP
3377: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
3378: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
3379: ,p_error_message out nocopy varchar2
3380: ,p_subjects_error_message out nocopy varchar2) IS
3381:

Line 3637: ,p_qua_subjects out nocopy SSHR_QUA_SUBJECT_TAB_TYP

3633: PROCEDURE get_entire_qua
3634: (p_transaction_step_id in varchar2
3635: ,p_mode out nocopy varchar2
3636: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
3637: ,p_qua_subjects out nocopy SSHR_QUA_SUBJECT_TAB_TYP
3638: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP) IS
3639:
3640: l_subject_count number;
3641: l_qua_count number := 1;

Line 3994: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();

3990: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3991:
3992:
3993: -- now get the subject details
3994: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();
3995:
3996: hr_utility.set_location('Entering For Loop:'||l_proc,30);
3997: FOR i IN 1..NVL(l_subject_count,0) LOOP
3998: p_qua_subjects.extend;