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_NO_SUPPORT_ORDER dependencies on PAY_NO_SUPPORT_ORDER

Line 1: PACKAGE BODY PAY_NO_SUPPORT_ORDER AS

1: PACKAGE BODY PAY_NO_SUPPORT_ORDER AS
2: /* $Header: pynosupord.pkb 120.5 2010/10/27 07:22:00 vijranga ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4:
5: ------------------------------------------------------------------------------------------------------

Line 64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

60: ) IS
61:
62:
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')

Line 65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')

61:
62:
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

62:
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')
70: ,effective_date

Line 67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))

63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')
70: ,effective_date
71: ,business_group_id

Line 68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')

64: SELECT PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')
70: ,effective_date
71: ,business_group_id
72: FROM pay_payroll_actions

Line 69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')

65: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ELEMENT_TYPE_ID')
66: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
67: ,fnd_date.canonical_to_date(PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'TO_DATE'))
68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')
70: ,effective_date
71: ,business_group_id
72: FROM pay_payroll_actions
73: WHERE payroll_action_id = p_payroll_action_id;

Line 292: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(

288: AND ppa.business_group_id = ppf.business_group_id
289: ORDER BY ppf.person_id';
290:
291: -- fetch the data for the REPORT DETAILS
292: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(
293: pactid
294: ,l_business_id
295: ,l_leg_emp_id
296: ,l_ele_type_id

Line 614: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(

610: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
611: END IF;
612:
613: -- fetch the data
614: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(
615: p_payroll_action_id
616: ,l_business_id
617: ,l_leg_emp_id
618: ,l_ele_type_id

Line 874: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(

870: WHERE assignment_action_id = p_assignment_action_id ;
871:
872:
873: -- fetch the data
874: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(
875: l_payroll_action_id
876: ,l_business_id
877: ,l_leg_emp_id
878: ,l_ele_type_id

Line 1301: END PAY_NO_SUPPORT_ORDER;

1297: END write_to_clob;
1298:
1299:
1300: -------------------------------------------------------------------------------------------------------------------------
1301: END PAY_NO_SUPPORT_ORDER;