DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PAY_NL_NSI_PROCESS

Line 1: package body PAY_NL_NSI_PROCESS as

1: package body PAY_NL_NSI_PROCESS as
2: /* $Header: pynlnsia.pkb 120.1 2005/09/26 05:09:24 summohan noship $ */
3: g_package varchar2(33) := ' PAY_NL_NSI_PROCESS.';
4:
5:

Line 3: g_package varchar2(33) := ' PAY_NL_NSI_PROCESS.';

1: package body PAY_NL_NSI_PROCESS as
2: /* $Header: pynlnsia.pkb 120.1 2005/09/26 05:09:24 summohan noship $ */
3: g_package varchar2(33) := ' PAY_NL_NSI_PROCESS.';
4:
5:
6: g_error_flag varchar2(30);
7: g_warning_flag varchar2(30);

Line 82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')

78: --
79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80:
81: SELECT
82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')
83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')

Line 83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')

79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80:
81: SELECT
82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')
83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')

Line 84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')

80:
81: SELECT
82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')
83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')
88: ,business_group_id

Line 85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')

81: SELECT
82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')
83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')
88: ,business_group_id
89: ,report_type

Line 86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')

82: PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'EMPLOYER_ID')
83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')
88: ,business_group_id
89: ,report_type
90: FROM pay_payroll_actions

Line 87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')

83: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'SI_PROVIDER_ID')
84: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'NSI_MONTH')
85: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'OUTPUT_MEDIA_TYPE')
86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')
88: ,business_group_id
89: ,report_type
90: FROM pay_payroll_actions
91: WHERE payroll_action_id = p_payroll_action_id;

Line 243: PAY_NL_NSI_PROCESS.get_all_parameters

239:
240: g_error_count := 0;
241: g_payroll_action_id:=pactid;
242:
243: PAY_NL_NSI_PROCESS.get_all_parameters
244: (p_payroll_action_id => pactid
245: ,p_business_group_id => l_business_group_id
246: ,p_employer_id => l_employer_id
247: ,p_si_provider_id => l_si_provider_id

Line 2011: PAY_NL_NSI_PROCESS.get_all_parameters

2007: --
2008: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
2009: g_warning_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','WARNING');
2010:
2011: PAY_NL_NSI_PROCESS.get_all_parameters
2012: (p_payroll_action_id => p_payroll_action_id
2013: ,p_business_group_id => l_business_group_id
2014: ,p_employer_id => l_employer_id
2015: ,p_si_provider_id => l_si_provider_id

Line 2234: END PAY_NL_NSI_PROCESS;

2230: hr_utility.set_location('Leaving Archive Code',800);
2231: --
2232: END ARCHIVE_CODE;
2233:
2234: END PAY_NL_NSI_PROCESS;