DBA Data[Home] [Help]

APPS.HR_QUA_AWARDS_UTIL_SS dependencies on SSHR_QUA_TAB_TYP

Line 115: l_qualifications SSHR_QUA_TAB_TYP;

111: ) is
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';

Line 193: (p_qualifications in SSHR_QUA_TAB_TYP

189: -- ---------------------------------------------------------------------------
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:

Line 1046: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP

1042: ,p_selected_person_id in varchar2
1043: ,p_mode in varchar2
1044: ,p_process_name in varchar2
1045: ,p_activity_name in varchar2
1046: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
1047: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP
1048: ,p_transaction_steps out nocopy SSHR_TRN_TAB_TYP
1049: )
1050: IS

Line 1057: l_qualifications SSHR_QUA_TAB_TYP;

1053: l_total_rec_count number := 0;
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';

Line 1076: p_qualifications := SSHR_QUA_TAB_TYP();

1072: ,p_transaction_step_id => l_transaction_step_id);
1073:
1074: l_total_rec_count := nvl(l_transaction_step_id.COUNT,0);
1075:
1076: p_qualifications := SSHR_QUA_TAB_TYP();
1077: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
1078: p_transaction_steps := SSHR_TRN_TAB_TYP();
1079:
1080: hr_utility.set_location('Entering For Loop:'||l_proc,10);

Line 1195: ,p_qualifications in SSHR_QUA_TAB_TYP

1191: ,p_act_id in varchar2
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;

Line 1331: ,p_qualifications in SSHR_QUA_TAB_TYP

1327: ,p_transaction_step_id in out nocopy number
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:

Line 2258: ,p_qualifications in SSHR_QUA_TAB_TYP

2254: PROCEDURE validate_api
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

Line 3163: ,p_qualifications in SSHR_QUA_TAB_TYP

3159:
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

Line 3423: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP

3419:
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;

Line 3548: p_qualifications := SSHR_QUA_TAB_TYP();

3544: );
3545: END LOOP;
3546: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3547:
3548: p_qualifications := SSHR_QUA_TAB_TYP();
3549:
3550: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3551: FOR i IN 1..NVL(l_qua_count,0) LOOP
3552: p_qualifications.extend;