DBA Data[Home] [Help]

APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_NO_K27_REIM_UPLD

Line 1: PACKAGE BODY PAY_NO_K27_REIM_UPLD AS

1: PACKAGE BODY PAY_NO_K27_REIM_UPLD AS
2: /* $Header: pynok27up.pkb 120.0.12020000.10 2013/03/28 04:40:59 smeduri noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_NO_K27_REIM_UPLD.';

Line 5: g_package VARCHAR2(33) := ' PAY_NO_K27_REIM_UPLD.';

1: PACKAGE BODY PAY_NO_K27_REIM_UPLD AS
2: /* $Header: pynok27up.pkb 120.0.12020000.10 2013/03/28 04:40:59 smeduri noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_NO_K27_REIM_UPLD.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;
9: g_legal_employer_id NUMBER;

Line 322: SELECT PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NUM')

318: ,p_period_date OUT NOCOPY DATE)
319: IS
320:
321: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
322: SELECT PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NUM')
323: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')
325: ,effective_date
326: ,business_group_id

Line 323: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')

319: IS
320:
321: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
322: SELECT PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NUM')
323: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')
325: ,effective_date
326: ,business_group_id
327: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'PERIOD_DATE')

Line 324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')

320:
321: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
322: SELECT PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NUM')
323: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')
325: ,effective_date
326: ,business_group_id
327: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'PERIOD_DATE')
328: FROM pay_payroll_actions

Line 327: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'PERIOD_DATE')

323: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')
325: ,effective_date
326: ,business_group_id
327: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'PERIOD_DATE')
328: FROM pay_payroll_actions
329: WHERE payroll_action_id = p_payroll_action_id;
330:
331: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';

Line 385: l_pkg varchar2(100) := 'PAY_NO_K27_REIM_UPLD.READ_K27_FILE';

381: invalid_file_format exception;
382: e_fatal_error exception;
383: no_rec_found_in_file exception;
384:
385: l_pkg varchar2(100) := 'PAY_NO_K27_REIM_UPLD.READ_K27_FILE';
386: l_action_info_id NUMBER;
387: l_ovn NUMBER;
388:
389: l_mun_sso_num VARCHAR2(4);

Line 1124: PAY_NO_K27_REIM_UPLD.GET_ALL_PARAMETERS

1120:
1121: hr_utility.set_location('RANGE_CODE:Before Calling GET_ALL_PARAMETERS',2);
1122: g_payroll_action_id := p_payroll_action_id;
1123:
1124: PAY_NO_K27_REIM_UPLD.GET_ALL_PARAMETERS
1125: ( p_payroll_action_id
1126: ,g_business_group_id
1127: ,l_employer_number
1128: ,g_effective_date

Line 1328: END PAY_NO_K27_REIM_UPLD;

1324: g_business_group_id :=NULL;
1325: g_effective_date :=NULL;
1326: g_test_submission :=NULL;
1327:
1328: END PAY_NO_K27_REIM_UPLD;