1: PACKAGE pay_cn_eft AS
2: /* $Header: pycneft.pkh 120.4 2006/12/13 12:38:56 sukukuma noship $ */
3:
4: level_cnt NUMBER;
5: g_start_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('START_DATE_PARAM');
6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');
7: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
2: /* $Header: pycneft.pkh 120.4 2006/12/13 12:38:56 sukukuma noship $ */
3:
4: level_cnt NUMBER;
5: g_start_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('START_DATE_PARAM');
6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');
7: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4: level_cnt NUMBER;
5: g_start_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('START_DATE_PARAM');
6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');
7: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
11: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
12: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');
7: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
11: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
12: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
13: g_legal_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
14: pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER_PARAM');
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
11: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
12: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
13: g_legal_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
14: pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER_PARAM');
15:
16:
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
11: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
12: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
13: g_legal_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
14: pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER_PARAM');
15:
16:
17:
18: --Cursor to retrieve CCBS Header Info