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.PAY_NL_SI_PKG dependencies on STANDARD

Line 10: /* Global Variables for Standard SI Part Time Percentage */

6: g_ptp_formula_exists BOOLEAN := TRUE;
7: g_ptp_formula_cached BOOLEAN := FALSE;
8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;

Line 20: /* Global Variables for Standard SI Reporting Part Time Percentage */

16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;

Line 612: -- Function : get_standard_si_part_time_perc

608: END IF;
609: RETURN fnd_number.canonical_to_number(l_part_time_perc);
610: END get_part_time_perc;
611: -------------------------------------------------------------------------------
612: -- Function : get_standard_si_part_time_perc
613: -- To get the Standard SI Part time Percentage using
614: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
615: ---------------------------------------------------------------------------------
616: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER

Line 613: -- To get the Standard SI Part time Percentage using

609: RETURN fnd_number.canonical_to_number(l_part_time_perc);
610: END get_part_time_perc;
611: -------------------------------------------------------------------------------
612: -- Function : get_standard_si_part_time_perc
613: -- To get the Standard SI Part time Percentage using
614: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
615: ---------------------------------------------------------------------------------
616: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER
617: ,p_date_earned IN DATE

Line 616: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER

612: -- Function : get_standard_si_part_time_perc
613: -- To get the Standard SI Part time Percentage using
614: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
615: ---------------------------------------------------------------------------------
616: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER
617: ,p_date_earned IN DATE
618: ,p_business_group_id IN NUMBER
619: ,p_assignment_action_id IN NUMBER) RETURN number IS
620: --

Line 634: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';

630: l_formula_exists BOOLEAN := TRUE;
631: l_formula_cached BOOLEAN := FALSE;
632: l_formula_id ff_formulas_f.formula_id%TYPE;
633: BEGIN
634: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';
635: --
636: OPEN csr_get_pay_action_id(p_assignment_action_id);
637: FETCH csr_get_pay_action_id INTO l_payroll_action_id;
638: CLOSE csr_get_pay_action_id;

Line 643: pay_nl_general.cache_formula('NL_STANDARD_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

639: --
640:
641: IF g_std_ptp_formula_exists = TRUE THEN
642: IF g_std_ptp_formula_cached = FALSE THEN
643: pay_nl_general.cache_formula('NL_STANDARD_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
644: g_std_ptp_formula_exists:=l_formula_exists;
645: g_std_ptp_formula_cached:=l_formula_cached;
646: g_std_ptp_formula_id:=l_formula_id;
647: END IF;

Line 665: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';

661: l_inputs(5).value := l_payroll_action_id;
662: l_inputs(6).name := 'BALANCE_DATE';
663: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
664: --
665: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
666: --
667: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,
668: p_effective_date => p_date_earned,
669: p_formula_name => g_std_ptp_formula_name,

Line 684: END get_standard_si_part_time_perc;

680: ELSIF g_std_ptp_formula_exists = FALSE THEN
681: l_part_time_perc := NULL;
682: END IF;
683: RETURN fnd_number.canonical_to_number(l_part_time_perc);
684: END get_standard_si_part_time_perc;
685: -------------------------------------------------------------------------------
686: -- Function : get_pseudo_si_part_time_perc
687: -- To get the Pseudo SI Part time Percentage using
688: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.

Line 761: -- To get the Standard SI Part time Percentage for Reporting using

757: RETURN fnd_number.canonical_to_number(l_part_time_perc);
758: END get_pseudo_si_part_time_perc;
759: -------------------------------------------------------------------------------
760: -- Function : get_std_si_rep_part_time_perc
761: -- To get the Standard SI Part time Percentage for Reporting using
762: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
763: ---------------------------------------------------------------------------------
764: FUNCTION get_std_si_rep_part_time_perc (p_assignment_id IN NUMBER
765: ,p_date_earned IN DATE

Line 782: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';

778: l_formula_exists BOOLEAN := TRUE;
779: l_formula_cached BOOLEAN := FALSE;
780: l_formula_id ff_formulas_f.formula_id%TYPE;
781: BEGIN
782: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
783: --
784: OPEN csr_get_pay_action_id(p_assignment_action_id);
785: FETCH csr_get_pay_action_id INTO l_payroll_action_id;
786: CLOSE csr_get_pay_action_id;

Line 790: pay_nl_general.cache_formula('NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

786: CLOSE csr_get_pay_action_id;
787: --
788: IF g_std_rep_ptp_formula_exists = TRUE THEN
789: IF g_std_rep_ptp_formula_cached = FALSE THEN
790: pay_nl_general.cache_formula('NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
791: g_std_rep_ptp_formula_exists:=l_formula_exists;
792: g_std_rep_ptp_formula_cached:=l_formula_cached;
793: g_std_rep_ptp_formula_id:=l_formula_id;
794: END IF;

Line 812: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';

808: l_inputs(5).value := l_payroll_action_id;
809: l_inputs(6).name := 'BALANCE_DATE';
810: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
811: --
812: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
813: --
814: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,
815: p_effective_date => p_date_earned,
816: p_formula_name => g_std_rep_ptp_formula_name,