APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_CALENDAR_PKG

Line 8218: hr_calendar_pkg.denormalise_calendar

8214: -- where availablity is QUALIFYING
8215: --
8216:
8217:
8218: hr_calendar_pkg.denormalise_calendar
8219: (p_purpose_usage_id => l_calendar_usages.purpose_usage_id
8220: ,p_primary_key_value => l_calendar_usages.primary_key_value
8221: ,p_period_from => p_schedule_start_date
8222: ,p_period_to => p_schedule_end_date + 1

Line 8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)

8233: -- FROM hr_scheduler_v sch
8234: -- WHERE availability = 'QUALIFYING';
8235: --
8236: -- expanding the hr_scheduler_v view
8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)
8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)

Line 8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')

8234: -- WHERE availability = 'QUALIFYING';
8235: --
8236: -- expanding the hr_scheduler_v view
8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)
8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)

Line 8239: -- ,hr_calendar_pkg.end_date(ROWNUM)

8235: --
8236: -- expanding the hr_scheduler_v view
8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)
8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)
8243: -- FROM fnd_common_lookups, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */

Line 8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')

8236: -- expanding the hr_scheduler_v view
8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)
8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)
8243: -- FROM fnd_common_lookups, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */
8244: -- fnd_common_lookups

Line 8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)

8237: -- SELECT hr_calendar_pkg.start_date(ROWNUM)
8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)
8243: -- FROM fnd_common_lookups, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */
8244: -- fnd_common_lookups
8245: -- WHERE ROWNUM <= hr_calendar_pkg.schedule_rowcount

Line 8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)

8238: -- ,TO_CHAR(hr_calendar_pkg.start_date(ROWNUM), 'HH24:MI')
8239: -- ,hr_calendar_pkg.end_date(ROWNUM)
8240: -- ,TO_CHAR(hr_calendar_pkg.end_date(ROWNUM), 'HH24:MI')
8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)
8243: -- FROM fnd_common_lookups, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */
8244: -- fnd_common_lookups
8245: -- WHERE ROWNUM <= hr_calendar_pkg.schedule_rowcount
8246: --APPS@hrukps:SQL>desc hr_scheduler_v

Line 8245: -- WHERE ROWNUM <= hr_calendar_pkg.schedule_rowcount

8241: -- ,SUBSTR(hr_calendar_pkg.availability_value(ROWNUM), 1, 80)
8242: -- ,hr_calendar_pkg.schedule_level_value(ROWNUM)
8243: -- FROM fnd_common_lookups, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */
8244: -- fnd_common_lookups
8245: -- WHERE ROWNUM <= hr_calendar_pkg.schedule_rowcount
8246: --APPS@hrukps:SQL>desc hr_scheduler_v
8247: --Name Null? Type
8248: --------------------------------- -------- ----
8249: --START_DATE DATE

Line 8257: -- for 1 to hr_calendar_pkg.schedule_rowcount

8253: --AVAILABILITY VARCHAR2(80)
8254: --SCHEDULE_LEVEL NUMBER
8255: --
8256: -- replace above logic with a plsql for loop
8257: -- for 1 to hr_calendar_pkg.schedule_rowcount
8258: -- the view had a cartesian join hence performance problems
8259: l_hr_scheduler_v_count := hr_calendar_pkg.schedule_rowcount;
8260: FOR i IN 1..l_hr_scheduler_v_count
8261: LOOP

Line 8259: l_hr_scheduler_v_count := hr_calendar_pkg.schedule_rowcount;

8255: --
8256: -- replace above logic with a plsql for loop
8257: -- for 1 to hr_calendar_pkg.schedule_rowcount
8258: -- the view had a cartesian join hence performance problems
8259: l_hr_scheduler_v_count := hr_calendar_pkg.schedule_rowcount;
8260: FOR i IN 1..l_hr_scheduler_v_count
8261: LOOP
8262: IF hr_calendar_pkg.availability_value(i) = 'QUALIFYING' THEN
8263: l_num_of_ssp_qualifying_days :=

Line 8262: IF hr_calendar_pkg.availability_value(i) = 'QUALIFYING' THEN

8258: -- the view had a cartesian join hence performance problems
8259: l_hr_scheduler_v_count := hr_calendar_pkg.schedule_rowcount;
8260: FOR i IN 1..l_hr_scheduler_v_count
8261: LOOP
8262: IF hr_calendar_pkg.availability_value(i) = 'QUALIFYING' THEN
8263: l_num_of_ssp_qualifying_days :=
8264: l_num_of_ssp_qualifying_days +
8265: NVL(TRUNC(hr_calendar_pkg.end_date(i)) - TRUNC(hr_calendar_pkg.start_date(i)),0);
8266: END IF;

Line 8265: NVL(TRUNC(hr_calendar_pkg.end_date(i)) - TRUNC(hr_calendar_pkg.start_date(i)),0);

8261: LOOP
8262: IF hr_calendar_pkg.availability_value(i) = 'QUALIFYING' THEN
8263: l_num_of_ssp_qualifying_days :=
8264: l_num_of_ssp_qualifying_days +
8265: NVL(TRUNC(hr_calendar_pkg.end_date(i)) - TRUNC(hr_calendar_pkg.start_date(i)),0);
8266: END IF;
8267: END LOOP;
8268: -- no date range needed, never use this view without doing the
8269: -- denormalize first for the require date range