DBA Data[Home] [Help]

APPS.PAY_IN_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 5: g_start_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('START_DATE_PARAM');

1: PACKAGE pay_in_eft AS
2: /* $Header: pyineft.pkh 120.2 2006/11/24 10:45:52 abhjain 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_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');
8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');
9:

Line 6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');

2: /* $Header: pyineft.pkh 120.2 2006/11/24 10:45:52 abhjain 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_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');
8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');
9:
10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=

Line 7: g_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');

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_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');
8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');
9:
10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');

Line 8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');

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_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');
8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');
9:
10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
12: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=

Line 11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');

7: g_pay_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('PAYMENT_DATE_PARAM');
8: g_trans_date CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('TRANSACTION_DATE');
9:
10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
12: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');

Line 13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

9:
10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
12: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
16: g_reg_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
17: pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER_PARAM');

Line 15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');

11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
12: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
16: g_reg_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
17: pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER_PARAM');
18:
19: --Cursor to retrieve Header Info

Line 17: pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER_PARAM');

13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
16: g_reg_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
17: pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER_PARAM');
18:
19: --Cursor to retrieve Header Info
20: CURSOR c_eft_header IS
21: SELECT 'COMPANY_NAME1=P'