DBA Data[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: BEGIN

Line 195: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 1047: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 1059: l_qua_attendance SSHR_QUA_ATTENDANCE_TAB_TYP;

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

Line 1077: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

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

Line 1197: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP) is

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

Line 1333: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 2260: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 3165: ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP

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

Line 3425: ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP) IS

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

Line 3445: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

3441: hr_transaction_api.get_varchar2_value
3442: (p_transaction_step_id => p_transaction_step_id
3443: ,p_name => 'P_SUBJECT_COUNT'));
3444:
3445: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
3446:
3447: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3448: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3449: p_qua_attendance.extend;