APPS.PAY_MX_FF_UDFS dependencies on STANDARD

Line 109: FUNCTION standard_hours_worked(

105: get_idw function.
106: */
107: l_vidw_effective_date DATE;
108:
109: FUNCTION standard_hours_worked(
110: p_std_hrs in NUMBER,
111: p_range_start in DATE,
112: p_range_end in DATE,
113: p_std_freq in VARCHAR2) RETURN NUMBER IS

Line 126: BEGIN -- standard_hours_worked

122: v_curr_date DATE;
123: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
124: v_day_no NUMBER;
125:
126: BEGIN -- standard_hours_worked
127:
128: /* Init */
129: c_wkdays_per_week := 5;
130: c_wkdays_per_month := 20;

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

134: v_curr_date := NULL;
135: v_curr_day :=NULL;
136:
137: -- Check for valid range
138: hr_utility.trace('Entered standard_hours_worked');
139:
140: IF p_range_start > p_range_end THEN
141: hr_utility.trace('p_range_start greater than p_range_end');
142: RETURN v_total_hours;

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

201: v_curr_date := v_curr_date + 1;
202: EXIT WHEN v_curr_date > p_range_end;
203: END LOOP;
204: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
205: hr_utility.trace(' Leaving standard_hours_worked' );
206: --
207: RETURN v_total_hours;
208: --
209: END standard_hours_worked;

Line 209: END standard_hours_worked;

205: hr_utility.trace(' Leaving standard_hours_worked' );
206: --
207: RETURN v_total_hours;
208: --
209: END standard_hours_worked;
210: --
211:
212: -- **********************************************************************
213: FUNCTION Convert_Period_Type(

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

369: v_work_sched_name,
370: v_range_start,
371: v_range_end);
372:
373: ELSE-- Hourly emp using Standard Hours on asg.
374:
375: hr_utility.trace(' Hourly emp using Standard Hours on asg');
376: hr_utility.trace(' calling Standard_Hours_Worked');
377:

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

371: v_range_end);
372:
373: ELSE-- Hourly emp using Standard Hours on asg.
374:
375: hr_utility.trace(' Hourly emp using Standard Hours on asg');
376: hr_utility.trace(' calling Standard_Hours_Worked');
377:
378: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
379: v_range_start,

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

372:
373: ELSE-- Hourly emp using Standard Hours on asg.
374:
375: hr_utility.trace(' Hourly emp using Standard Hours on asg');
376: hr_utility.trace(' calling Standard_Hours_Worked');
377:
378: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
379: v_range_start,
380: v_range_end,

Line 378: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

374:
375: hr_utility.trace(' Hourly emp using Standard Hours on asg');
376: hr_utility.trace(' calling Standard_Hours_Worked');
377:
378: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
379: v_range_start,
380: v_range_end,
381: p_asg_std_freq);
382:

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

525: v_work_sched_name,
526: v_range_start,
527: v_range_end);
528:
529: ELSE-- Hourly emp using Standard Hours on asg.
530:
531: hr_utility.trace(' Hourly emp using Standard Hours on asg');
532:
533: hr_utility.trace('calling Standard_Hours_Worked');

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

527: v_range_end);
528:
529: ELSE-- Hourly emp using Standard Hours on asg.
530:
531: hr_utility.trace(' Hourly emp using Standard Hours on asg');
532:
533: hr_utility.trace('calling Standard_Hours_Worked');
534:
535: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

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

529: ELSE-- Hourly emp using Standard Hours on asg.
530:
531: hr_utility.trace(' Hourly emp using Standard Hours on asg');
532:
533: hr_utility.trace('calling Standard_Hours_Worked');
534:
535: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
536: v_range_start,
537: v_range_end,

Line 535: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

531: hr_utility.trace(' Hourly emp using Standard Hours on asg');
532:
533: hr_utility.trace('calling Standard_Hours_Worked');
534:
535: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
536: v_range_start,
537: v_range_end,
538: p_asg_std_freq);
539:

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

536: v_range_start,
537: v_range_end,
538: p_asg_std_freq);
539:
540: hr_utility.trace('returned Standard_Hours_Worked');
541: END IF;
542:
543:
544: IF v_period_hours THEN