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 194: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

190: -- is_entire_qua_changed
191: -- ---------------------------------------------------------------------------
192: FUNCTION is_entire_qua_changed
193: (p_qualifications in SSHR_QUA_TAB_TYP
194: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
195: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
196: )
197:
198: RETURN BOOLEAN IS

Line 1058: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;

1054:
1055: l_mode varchar2(2000);
1056:
1057: l_qualifications SSHR_QUA_TAB_TYP;
1058: l_qua_subjects SSHR_QUA_SUBJECT_TAB_TYP;
1059: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;
1060: l_selected_person_id number;
1061: l_proc varchar2(72) := g_package||'get_pending_transaction_ids';
1062:

Line 1196: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

1192: ,p_proc_call in varchar2
1193: ,p_error_message in out nocopy varchar2
1194: ,p_subjects_error_message in out nocopy varchar2
1195: ,p_qualifications in SSHR_QUA_TAB_TYP
1196: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
1197: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP) is
1198:
1199: l_app_exception exception;
1200:

Line 1332: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

1328: ,p_mode in varchar2
1329: ,p_creator_person_id in number
1330: ,p_selected_person_id in number
1331: ,p_qualifications in SSHR_QUA_TAB_TYP
1332: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
1333: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
1334: ,p_proc_call in varchar2 ) IS
1335:
1336: l_result VARCHAR2(100);

Line 2259: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

2255: (p_validate in boolean
2256: ,p_mode in varchar2
2257: ,p_selected_person_id in number
2258: ,p_qualifications in SSHR_QUA_TAB_TYP
2259: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
2260: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
2261: ) IS
2262: CURSOR csr_school_changed(p_establishment in varchar2
2263: ,p_attendance_id in number

Line 3164: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP

3160: PROCEDURE check_errors
3161: (p_ignore_sub_date_boundaries in varchar2
3162: ,p_mode in varchar2
3163: ,p_qualifications in SSHR_QUA_TAB_TYP
3164: ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
3165: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
3166: ,p_error_message out nocopy varchar2
3167: ,p_subjects_error_message out nocopy varchar2) IS
3168:

Line 3424: ,p_qua_subjects out nocopy SSHR_QUA_SUBJECT_TAB_TYP

3420: PROCEDURE get_entire_qua
3421: (p_transaction_step_id in varchar2
3422: ,p_mode out nocopy varchar2
3423: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
3424: ,p_qua_subjects out nocopy SSHR_QUA_SUBJECT_TAB_TYP
3425: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP) IS
3426:
3427: l_subject_count number;
3428: l_qua_count number := 1;

Line 3781: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();

3777: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3778:
3779:
3780: -- now get the subject details
3781: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();
3782:
3783: hr_utility.set_location('Entering For Loop:'||l_proc,30);
3784: FOR i IN 1..NVL(l_subject_count,0) LOOP
3785: p_qua_subjects.extend;