APPS.PQH_COMMITMENT_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 684: no_periods per_time_period_types.number_per_fiscal_year%type := NULL;

680: p_multiple out nocopy number) is
681: --
682: proc_name varchar2(72) := 'get_period_details';
683: --
684: no_periods per_time_period_types.number_per_fiscal_year%type := NULL;
685: --
686: Cursor csr_period_types is
687: select tp.number_per_fiscal_year
688: from per_time_period_types tp

Line 688: from per_time_period_types tp

684: no_periods per_time_period_types.number_per_fiscal_year%type := NULL;
685: --
686: Cursor csr_period_types is
687: select tp.number_per_fiscal_year
688: from per_time_period_types tp
689: where tp.period_type = p_proc_period_type;
690: --
691: begin
692: hr_utility.set_location('Entering:'||proc_name, 5);

Line 1163: l_number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type;

1159: -- occurs in a year.
1160: --
1161: Function get_number_per_fiscal_year(p_frequency in varchar2) RETURN NUMBER is
1162: --
1163: l_number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type;
1164: --
1165: Cursor csr_period_type is
1166: SELECT PT.number_per_fiscal_year
1167: FROM per_time_period_types PT

Line 1167: FROM per_time_period_types PT

1163: l_number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type;
1164: --
1165: Cursor csr_period_type is
1166: SELECT PT.number_per_fiscal_year
1167: FROM per_time_period_types PT
1168: WHERE UPPER(PT.period_type) = UPPER(p_frequency);
1169:
1170: l_check hr_lookups.meaning%type;
1171: l_proc varchar2(72) := g_package||'get_number_per_fiscal_year';

Line 3514: -- Check if the frequency is in per_time_period_types.

3510:
3511: IF v_use_pay_basis = 0 THEN
3512: --
3513: -- If Not using pay basis as frequency...
3514: -- Check if the frequency is in per_time_period_types.
3515: -- The Budget Calendar frequency is the period type of the budgets
3516: -- Calendar . The valid set of period types are available in
3517: -- per_time_period_types .
3518: -- This set will be used to validate if the input element frequency is

Line 3517: -- per_time_period_types .

3513: -- If Not using pay basis as frequency...
3514: -- Check if the frequency is in per_time_period_types.
3515: -- The Budget Calendar frequency is the period type of the budgets
3516: -- Calendar . The valid set of period types are available in
3517: -- per_time_period_types .
3518: -- This set will be used to validate if the input element frequency is
3519: -- valid.
3520: -- If input element frequency is not valid ,fall back on budget element frequency .
3521:

Line 3549: -- This is an actual time period type from per_time_period_types.

3545: End if;
3546: --
3547: ELSIF UPPER(p_freq) <> 'HOURLY' THEN
3548: --
3549: -- This is an actual time period type from per_time_period_types.
3550: -- We know how to handle this.
3551: --
3552: --
3553: BEGIN

Line 3559: FROM per_time_period_types PT

3555: hr_utility.set_location('Get_Annualizing_Factor',75);
3556:
3557: SELECT PT.number_per_fiscal_year
3558: INTO v_annualizing_factor
3559: FROM per_time_period_types PT
3560: WHERE UPPER(PT.period_type) = UPPER(p_freq);
3561:
3562: hr_utility.set_location('Get_Annualizing_Factor',80);
3563: --