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_ATTENDANCE_TAB_TYP

Line 117: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;

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

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 393: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 1245: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 1257: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;

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:
1261: BEGIN

Line 1275: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

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);
1279: FOR i IN 1..l_total_rec_count LOOP

Line 1395: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP) is

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:
1399: l_transaction_step_id number;

Line 1531: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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);
1535: l_transaction_id number;

Line 2458: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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
2462: ,p_establishment_id in number)

Line 3378: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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:
3382: cursor c1(p_start_date in date,

Line 3638: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP) IS

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;
3642: l_attendance_count number := 1;

Line 3658: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

3654: hr_transaction_api.get_varchar2_value
3655: (p_transaction_step_id => p_transaction_step_id
3656: ,p_name => 'P_SUBJECT_COUNT'));
3657:
3658: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
3659:
3660: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3661: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3662: p_qua_attendance.extend;