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 595: -- Function : get_standard_si_part_time_perc

591: END IF;
592: RETURN fnd_number.canonical_to_number(l_part_time_perc);
593: END get_part_time_perc;
594: -------------------------------------------------------------------------------
595: -- Function : get_standard_si_part_time_perc
596: -- To get the Standard SI Part time Percentage using
597: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
598: ---------------------------------------------------------------------------------
599: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER

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

592: RETURN fnd_number.canonical_to_number(l_part_time_perc);
593: END get_part_time_perc;
594: -------------------------------------------------------------------------------
595: -- Function : get_standard_si_part_time_perc
596: -- To get the Standard SI Part time Percentage using
597: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
598: ---------------------------------------------------------------------------------
599: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER
600: ,p_date_earned IN DATE

Line 599: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER

595: -- Function : get_standard_si_part_time_perc
596: -- To get the Standard SI Part time Percentage using
597: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
598: ---------------------------------------------------------------------------------
599: FUNCTION get_standard_si_part_time_perc (p_assignment_id IN NUMBER
600: ,p_date_earned IN DATE
601: ,p_business_group_id IN NUMBER
602: ,p_assignment_action_id IN NUMBER) RETURN number IS
603: --

Line 617: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';

613: l_formula_exists BOOLEAN := TRUE;
614: l_formula_cached BOOLEAN := FALSE;
615: l_formula_id ff_formulas_f.formula_id%TYPE;
616: BEGIN
617: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';
618: --
619: OPEN csr_get_pay_action_id(p_assignment_action_id);
620: FETCH csr_get_pay_action_id INTO l_payroll_action_id;
621: CLOSE csr_get_pay_action_id;

Line 626: 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);

622: --
623:
624: IF g_std_ptp_formula_exists = TRUE THEN
625: IF g_std_ptp_formula_cached = FALSE THEN
626: 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);
627: g_std_ptp_formula_exists:=l_formula_exists;
628: g_std_ptp_formula_cached:=l_formula_cached;
629: g_std_ptp_formula_id:=l_formula_id;
630: END IF;

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

644: l_inputs(5).value := l_payroll_action_id;
645: l_inputs(6).name := 'BALANCE_DATE';
646: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
647: --
648: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
649: --
650: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,
651: p_effective_date => p_date_earned,
652: p_formula_name => g_std_ptp_formula_name,

Line 667: END get_standard_si_part_time_perc;

663: ELSIF g_std_ptp_formula_exists = FALSE THEN
664: l_part_time_perc := NULL;
665: END IF;
666: RETURN fnd_number.canonical_to_number(l_part_time_perc);
667: END get_standard_si_part_time_perc;
668: -------------------------------------------------------------------------------
669: -- Function : get_pseudo_si_part_time_perc
670: -- To get the Pseudo SI Part time Percentage using
671: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.

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

740: RETURN fnd_number.canonical_to_number(l_part_time_perc);
741: END get_pseudo_si_part_time_perc;
742: -------------------------------------------------------------------------------
743: -- Function : get_std_si_rep_part_time_perc
744: -- To get the Standard SI Part time Percentage for Reporting using
745: -- Assignment Id,Date Earned, Business Group Id and Assignment action Id.
746: ---------------------------------------------------------------------------------
747: FUNCTION get_std_si_rep_part_time_perc (p_assignment_id IN NUMBER
748: ,p_date_earned IN DATE

Line 765: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';

761: l_formula_exists BOOLEAN := TRUE;
762: l_formula_cached BOOLEAN := FALSE;
763: l_formula_id ff_formulas_f.formula_id%TYPE;
764: BEGIN
765: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
766: --
767: OPEN csr_get_pay_action_id(p_assignment_action_id);
768: FETCH csr_get_pay_action_id INTO l_payroll_action_id;
769: CLOSE csr_get_pay_action_id;

Line 773: 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);

769: CLOSE csr_get_pay_action_id;
770: --
771: IF g_std_rep_ptp_formula_exists = TRUE THEN
772: IF g_std_rep_ptp_formula_cached = FALSE THEN
773: 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);
774: g_std_rep_ptp_formula_exists:=l_formula_exists;
775: g_std_rep_ptp_formula_cached:=l_formula_cached;
776: g_std_rep_ptp_formula_id:=l_formula_id;
777: END IF;

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

791: l_inputs(5).value := l_payroll_action_id;
792: l_inputs(6).name := 'BALANCE_DATE';
793: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
794: --
795: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
796: --
797: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,
798: p_effective_date => p_date_earned,
799: p_formula_name => g_std_rep_ptp_formula_name,