APPS.PAY_MX_FF_UDFS dependencies on STANDARD

Line 96: FUNCTION standard_hours_worked(

92: added in get_contract_name procedure.
93: */
94:
95:
96: FUNCTION standard_hours_worked(
97: p_std_hrs in NUMBER,
98: p_range_start in DATE,
99: p_range_end in DATE,
100: p_std_freq in VARCHAR2) RETURN NUMBER IS

Line 113: BEGIN -- standard_hours_worked

109: v_curr_date DATE;
110: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
111: v_day_no NUMBER;
112:
113: BEGIN -- standard_hours_worked
114:
115: /* Init */
116: c_wkdays_per_week := 5;
117: c_wkdays_per_month := 20;

Line 125: hr_utility.trace('Entered standard_hours_worked');

121: v_curr_date := NULL;
122: v_curr_day :=NULL;
123:
124: -- Check for valid range
125: hr_utility.trace('Entered standard_hours_worked');
126:
127: IF p_range_start > p_range_end THEN
128: hr_utility.trace('p_range_start greater than p_range_end');
129: RETURN v_total_hours;

Line 192: hr_utility.trace(' Leaving standard_hours_worked' );

188: v_curr_date := v_curr_date + 1;
189: EXIT WHEN v_curr_date > p_range_end;
190: END LOOP;
191: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
192: hr_utility.trace(' Leaving standard_hours_worked' );
193: --
194: RETURN v_total_hours;
195: --
196: END standard_hours_worked;

Line 196: END standard_hours_worked;

192: hr_utility.trace(' Leaving standard_hours_worked' );
193: --
194: RETURN v_total_hours;
195: --
196: END standard_hours_worked;
197: --
198:
199: -- **********************************************************************
200: FUNCTION Convert_Period_Type(

Line 360: ELSE-- Hourly emp using Standard Hours on asg.

356: v_work_sched_name,
357: v_range_start,
358: v_range_end);
359:
360: ELSE-- Hourly emp using Standard Hours on asg.
361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:

Line 362: hr_utility.trace(' Hourly emp using Standard Hours on asg');

358: v_range_end);
359:
360: ELSE-- Hourly emp using Standard Hours on asg.
361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:
365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
366: v_range_start,

Line 363: hr_utility.trace(' calling Standard_Hours_Worked');

359:
360: ELSE-- Hourly emp using Standard Hours on asg.
361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:
365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
366: v_range_start,
367: v_range_end,

Line 365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:
365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
366: v_range_start,
367: v_range_end,
368: p_asg_std_freq);
369:

Line 516: ELSE-- Hourly emp using Standard Hours on asg.

512: v_work_sched_name,
513: v_range_start,
514: v_range_end);
515:
516: ELSE-- Hourly emp using Standard Hours on asg.
517:
518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');

Line 518: hr_utility.trace(' Hourly emp using Standard Hours on asg');

514: v_range_end);
515:
516: ELSE-- Hourly emp using Standard Hours on asg.
517:
518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');
521:
522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

Line 520: hr_utility.trace('calling Standard_Hours_Worked');

516: ELSE-- Hourly emp using Standard Hours on asg.
517:
518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');
521:
522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
523: v_range_start,
524: v_range_end,

Line 522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');
521:
522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
523: v_range_start,
524: v_range_end,
525: p_asg_std_freq);
526:

Line 527: hr_utility.trace('returned Standard_Hours_Worked');

523: v_range_start,
524: v_range_end,
525: p_asg_std_freq);
526:
527: hr_utility.trace('returned Standard_Hours_Worked');
528: END IF;
529:
530:
531: IF v_period_hours THEN