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.

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on PQP_ABSVAL_PKG

Line 171: l_entitlements pqp_absval_pkg.t_entitlements;

167: ) IS
168:
169: invalid_length_of_service EXCEPTION;
170:
171: l_entitlements pqp_absval_pkg.t_entitlements;
172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.

Line 172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;

168:
169: invalid_length_of_service EXCEPTION;
170:
171: l_entitlements pqp_absval_pkg.t_entitlements;
172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.
176: object_version_number%TYPE;

Line 173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;

169: invalid_length_of_service EXCEPTION;
170:
171: l_entitlements pqp_absval_pkg.t_entitlements;
172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.
176: object_version_number%TYPE;
177: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;

Line 174: l_daily_absences pqp_absval_pkg.t_daily_absences;

170:
171: l_entitlements pqp_absval_pkg.t_entitlements;
172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.
176: object_version_number%TYPE;
177: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
178:

Line 177: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;

173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.
176: object_version_number%TYPE;
177: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
178:
179: l_plan_information rec_plan_information ;
180:
181: l_generate_start_date DATE;

Line 386: pqp_absval_pkg.generate_daily_absences(

382: END IF ;
383: -- check the available entitlements and process the days and populate
384: -- the pl/sql with the records to be inserted into daily absences table.
385:
386: pqp_absval_pkg.generate_daily_absences(
387: p_assignment_id => p_assignment_id
388: ,p_business_group_id => p_business_group_id
389: ,p_absence_attendance_id => p_absence_id
390: ,p_default_work_pattern_name => l_plan_information.default_work_pattern

Line 412: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);

408: debug(l_proc_name,50);
409: END IF ;
410:
411:
412: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
413: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
414: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
415:
416: IF g_debug THEN

Line 413: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;

409: END IF ;
410:
411:
412: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
413: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
414: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
415:
416: IF g_debug THEN
417: l_proc_step := 50 ;

Line 414: CLOSE pqp_absval_pkg.csr_gap_absence_plan;

410:
411:
412: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
413: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
414: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
415:
416: IF g_debug THEN
417: l_proc_step := 50 ;
418: debug(l_proc_name,50);

Line 480: pqp_absval_pkg.write_daily_absences

476: l_proc_step := 75 ;
477: debug(l_proc_name, 75) ;
478: END IF;
479:
480: pqp_absval_pkg.write_daily_absences
481: (p_daily_absences => l_daily_absences
482: ,p_gap_absence_plan_id => l_gap_absence_plan.gap_absence_plan_id );
483:
484: IF g_debug THEN

Line 497: pqp_absval_pkg.write_absence_summary

493:
494: IF g_debug THEN
495: debug(l_proc_name, 85);
496: END IF;
497: pqp_absval_pkg.write_absence_summary
498: (P_GAP_ABSENCE_PLAN_ID => l_gap_absence_plan.gap_absence_plan_id
499: ,P_ASSIGNMENT_ID => p_assignment_id
500: ,P_ENTITLEMENT_GRANTED => l_entitlements
501: ,P_ENTITLEMENT_USED_TO_DATE => l_absences_taken_to_date

Line 560: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

556: ,p_absence_id IN NUMBER
557: ,p_absence_ent_uom IN VARCHAR2
558: ,p_start_date IN DATE
559: ,p_benefits_length_of_service IN NUMBER
560: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
561: ,p_error_code OUT NOCOPY NUMBER
562: ,p_message OUT NOCOPY VARCHAR2
563: ) IS
564: l_intend_to_return VARCHAR2(1) ;

Line 567: l_entitlements_nc pqp_absval_pkg.t_entitlements := p_entitlements ;

563: ) IS
564: l_intend_to_return VARCHAR2(1) ;
565: l_start_date DATE := p_start_date ;
566: l_end_date DATE ;
567: l_entitlements_nc pqp_absval_pkg.t_entitlements := p_entitlements ;
568: l_proc_name VARCHAR2(61) := g_package_name||'get_entitlement_info';
569: l_proc_step NUMBER(20,10);
570: l_is_ent_override BOOLEAN ;
571:

Line 717: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

713: ,p_business_group_id IN NUMBER
714: ,p_effective_date IN DATE
715: ,p_absence_id IN NUMBER
716: ,p_pl_typ_id IN NUMBER
717: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
718: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
719: ,p_lookup_type IN VARCHAR2
720: ,p_error_code OUT NOCOPY NUMBER
721: ,p_message OUT NOCOPY VARCHAR2 ) IS

Line 718: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements

714: ,p_effective_date IN DATE
715: ,p_absence_id IN NUMBER
716: ,p_pl_typ_id IN NUMBER
717: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
718: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
719: ,p_lookup_type IN VARCHAR2
720: ,p_error_code OUT NOCOPY NUMBER
721: ,p_message OUT NOCOPY VARCHAR2 ) IS
722:

Line 726: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements ;

722:
723: l_get_band_bal csr_get_band_bal%ROWTYPE;
724: l_flag VARCHAR2(1):='N';
725: l_count NUMBER := 0 ;
726: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements ;
727: l_proc_name VARCHAR2(61) := g_package_name||'get_entitlements_consumed';
728: l_proc_step NUMBER(20,10) ;
729:
730: BEGIN

Line 860: (p_entitlements IN pqp_absval_pkg.t_entitlements

856:
857:
858: --This Procedure calculates remaining entitlements
859: PROCEDURE get_entitlements_remaining
860: (p_entitlements IN pqp_absval_pkg.t_entitlements
861: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
862: ,p_entitlement_UOM IN VARCHAR2
863: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
864: ,p_error_code OUT NOCOPY NUMBER

Line 861: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements

857:
858: --This Procedure calculates remaining entitlements
859: PROCEDURE get_entitlements_remaining
860: (p_entitlements IN pqp_absval_pkg.t_entitlements
861: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
862: ,p_entitlement_UOM IN VARCHAR2
863: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
864: ,p_error_code OUT NOCOPY NUMBER
865: ,p_message OUT NOCOPY VARCHAR2

Line 863: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements

859: PROCEDURE get_entitlements_remaining
860: (p_entitlements IN pqp_absval_pkg.t_entitlements
861: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
862: ,p_entitlement_UOM IN VARCHAR2
863: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
864: ,p_error_code OUT NOCOPY NUMBER
865: ,p_message OUT NOCOPY VARCHAR2
866: )
867: IS

Line 1250: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;

1246: )
1247: IS
1248:
1249: l_absence_end_date DATE;
1250: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
1251: l_first_entitled_day_of_noband pqp_absval_pkg.csr_first_entitled_day_of_band%ROWTYPE;
1252: l_error_code fnd_new_messages.message_number%TYPE:=0;
1253: l_error_message fnd_new_messages.message_text%TYPE;
1254:

Line 1251: l_first_entitled_day_of_noband pqp_absval_pkg.csr_first_entitled_day_of_band%ROWTYPE;

1247: IS
1248:
1249: l_absence_end_date DATE;
1250: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
1251: l_first_entitled_day_of_noband pqp_absval_pkg.csr_first_entitled_day_of_band%ROWTYPE;
1252: l_error_code fnd_new_messages.message_number%TYPE:=0;
1253: l_error_message fnd_new_messages.message_text%TYPE;
1254:
1255: l_proc_name VARCHAR2(61):=

Line 1279: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);

1275: debug( p_update_start_date);
1276: debug(p_update_end_date );
1277: END IF ;
1278:
1279: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
1280: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
1281: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
1282:
1283: IF g_debug THEN

Line 1280: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;

1276: debug(p_update_end_date );
1277: END IF ;
1278:
1279: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
1280: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
1281: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
1282:
1283: IF g_debug THEN
1284: l_proc_step := 10 ;

Line 1281: CLOSE pqp_absval_pkg.csr_gap_absence_plan;

1277: END IF ;
1278:
1279: OPEN pqp_absval_pkg.csr_gap_absence_plan(p_absence_id, p_pl_id);
1280: FETCH pqp_absval_pkg.csr_gap_absence_plan INTO l_gap_absence_plan;
1281: CLOSE pqp_absval_pkg.csr_gap_absence_plan;
1282:
1283: IF g_debug THEN
1284: l_proc_step := 10 ;
1285: debug(l_proc_name,10);

Line 1295: OPEN pqp_absval_pkg.csr_first_entitled_day_of_band

1291: l_proc_step := 15 ;
1292: debug(l_proc_name,15);
1293: END IF ;
1294:
1295: OPEN pqp_absval_pkg.csr_first_entitled_day_of_band
1296: (l_gap_absence_plan.gap_absence_plan_id
1297: ,'NOBAND'
1298: );
1299:

Line 1300: FETCH pqp_absval_pkg.csr_first_entitled_day_of_band INTO l_first_entitled_day_of_noband;

1296: (l_gap_absence_plan.gap_absence_plan_id
1297: ,'NOBAND'
1298: );
1299:
1300: FETCH pqp_absval_pkg.csr_first_entitled_day_of_band INTO l_first_entitled_day_of_noband;
1301:
1302: IF pqp_absval_pkg.csr_first_entitled_day_of_band%FOUND
1303: THEN
1304: IF g_debug THEN

Line 1302: IF pqp_absval_pkg.csr_first_entitled_day_of_band%FOUND

1298: );
1299:
1300: FETCH pqp_absval_pkg.csr_first_entitled_day_of_band INTO l_first_entitled_day_of_noband;
1301:
1302: IF pqp_absval_pkg.csr_first_entitled_day_of_band%FOUND
1303: THEN
1304: IF g_debug THEN
1305: l_proc_step := 20 ;
1306: debug(l_proc_name,20);

Line 1322: CLOSE pqp_absval_pkg.csr_first_entitled_day_of_band;

1318: END IF; -- IF l_first_entitled_day_of_noband.absence_date + 365
1319:
1320: END IF; -- IF csr_first_entitled_day_of_band%FOUND THEN
1321:
1322: CLOSE pqp_absval_pkg.csr_first_entitled_day_of_band;
1323:
1324: IF g_debug THEN
1325: l_proc_step := 25 ;
1326: debug(l_proc_name,25);

Line 1384: pqp_absval_pkg.delete_absence_plan_details

1380: debug(l_proc_name,45);
1381: END IF ;
1382:
1383:
1384: pqp_absval_pkg.delete_absence_plan_details
1385: (p_assignment_id => p_assignment_id
1386: ,p_business_group_id => p_business_group_id
1387: ,p_plan_id => p_pl_id
1388: ,p_absence_id => p_absence_id

Line 1439: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements

1435: p_assignment_id IN NUMBER
1436: ,p_business_group_id IN NUMBER
1437: ,p_pl_typ_id IN NUMBER
1438: ,p_effective_date IN DATE
1439: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
1440: ,p_error_code OUT NOCOPY NUMBER
1441: ,p_message OUT NOCOPY VARCHAR2
1442: )
1443: IS