eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 211: FUNCTION is_attendance_changed (p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP,p_qualifications in SSHR_QUA_TAB_TYP)

207: New function introduced to verify if there are any changes done to school information
208:
209: */
210:
211: FUNCTION is_attendance_changed (p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP,p_qualifications in SSHR_QUA_TAB_TYP)
212: RETURN BOOLEAN IS
213:
214: cursor csr_attendance(p_attendance_id in number) is
215: select *

Line 391: (p_qualifications in SSHR_QUA_TAB_TYP

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

Line 1244: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP

1240: ,p_selected_person_id in varchar2
1241: ,p_mode in varchar2
1242: ,p_process_name in varchar2
1243: ,p_activity_name in varchar2
1244: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
1245: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP
1246: ,p_transaction_steps out nocopy SSHR_TRN_TAB_TYP
1247: )
1248: IS

Line 1255: l_qualifications SSHR_QUA_TAB_TYP;

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

Line 1274: p_qualifications := SSHR_QUA_TAB_TYP();

1270: ,p_transaction_step_id => l_transaction_step_id);
1271:
1272: l_total_rec_count := nvl(l_transaction_step_id.COUNT,0);
1273:
1274: p_qualifications := SSHR_QUA_TAB_TYP();
1275: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
1276: p_transaction_steps := SSHR_TRN_TAB_TYP();
1277:
1278: hr_utility.set_location('Entering For Loop:'||l_proc,10);

Line 1393: ,p_qualifications in SSHR_QUA_TAB_TYP

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

Line 1529: ,p_qualifications in SSHR_QUA_TAB_TYP

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

Line 2456: ,p_qualifications in SSHR_QUA_TAB_TYP

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

Line 3376: ,p_qualifications in SSHR_QUA_TAB_TYP

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

Line 3636: ,p_qualifications out nocopy SSHR_QUA_TAB_TYP

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

Line 3761: p_qualifications := SSHR_QUA_TAB_TYP();

3757: );
3758: END LOOP;
3759: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3760:
3761: p_qualifications := SSHR_QUA_TAB_TYP();
3762:
3763: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3764: FOR i IN 1..NVL(l_qua_count,0) LOOP
3765: p_qualifications.extend;