APPS.PAY_EOSY_AC_PKG dependencies on PAY_EOSY_AC_PKG

Line 1: PACKAGE BODY pay_eosy_ac_pkg AS

1: PACKAGE BODY pay_eosy_ac_pkg AS
2: /* $Header: pyuseoac.pkb 120.0.12000000.2 2007/07/16 17:31:14 rpasumar noship $ */
3: /*
4: ******************************************************************
5: * *

Line 51: l_package := 'pay_eosy_ac_pkg.range_cursor';

47: l_package varchar2(70);
48:
49: Begin
50:
51: l_package := 'pay_eosy_ac_pkg.range_cursor';
52: --hr_utility.trace_on(null,'fusman');
53: hr_utility.set_location('Entering.. ' || l_package,10);
54:
55: sqlstr:=

Line 64: AND pghn.hierarchy_version_id = pay_eosy_ac_pkg.get_parameter

60: per_assignment_status_types past,
61: per_jobs pj,
62: fnd_common_lookups fcl
63: where ppa.payroll_action_id = :pactid
64: AND pghn.hierarchy_version_id = pay_eosy_ac_pkg.get_parameter
65: (''HI_VER_ID'',ppa.legislative_parameters)
66: AND (
67: (
68: entity_id = nvl(pay_eosy_ac_pkg.get_parameter

Line 68: entity_id = nvl(pay_eosy_ac_pkg.get_parameter

64: AND pghn.hierarchy_version_id = pay_eosy_ac_pkg.get_parameter
65: (''HI_VER_ID'',ppa.legislative_parameters)
66: AND (
67: (
68: entity_id = nvl(pay_eosy_ac_pkg.get_parameter
69: (''EST_ID'',ppa.legislative_parameters),pghn.entity_id)
70: AND node_type =''EST''
71: )
72: OR

Line 76: WHERE hierarchy_version_id =pay_eosy_ac_pkg.get_parameter

72: OR
73: (
74: parent_hierarchy_node_id in(SELECT hierarchy_node_id
75: FROM per_gen_hierarchy_nodes
76: WHERE hierarchy_version_id =pay_eosy_ac_pkg.get_parameter
77: (''HI_VER_ID'',ppa.legislative_parameters)
78: AND entity_id = nvl(pay_eosy_ac_pkg.get_parameter
79: (''EST_ID'',ppa.legislative_parameters),entity_id)
80: AND node_type = ''EST'')

Line 78: AND entity_id = nvl(pay_eosy_ac_pkg.get_parameter

74: parent_hierarchy_node_id in(SELECT hierarchy_node_id
75: FROM per_gen_hierarchy_nodes
76: WHERE hierarchy_version_id =pay_eosy_ac_pkg.get_parameter
77: (''HI_VER_ID'',ppa.legislative_parameters)
78: AND entity_id = nvl(pay_eosy_ac_pkg.get_parameter
79: (''EST_ID'',ppa.legislative_parameters),entity_id)
80: AND node_type = ''EST'')
81: AND node_type = ''LOC''
82: )

Line 214: pay_eosy_ac_pkg.get_parameter('HI_VER_ID',legislative_parameters),

210: CURSOR c_report_parameters(pactid number)
211: IS
212: SELECT start_date,
213: effective_date,
214: pay_eosy_ac_pkg.get_parameter('HI_VER_ID',legislative_parameters),
215: pay_eosy_ac_pkg.get_parameter('EST_ID',legislative_parameters)
216: FROM pay_payroll_actions
217: WHERE payroll_action_id=pactid;
218:

Line 215: pay_eosy_ac_pkg.get_parameter('EST_ID',legislative_parameters)

211: IS
212: SELECT start_date,
213: effective_date,
214: pay_eosy_ac_pkg.get_parameter('HI_VER_ID',legislative_parameters),
215: pay_eosy_ac_pkg.get_parameter('EST_ID',legislative_parameters)
216: FROM pay_payroll_actions
217: WHERE payroll_action_id=pactid;
218:
219: lockingactid number;

Line 235: l_package := 'pay_eosy_ac_pkg.action_creation';

231: BEGIN
232:
233: --hr_utility.trace_on(null,'fusman');
234:
235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);

Line 353: END pay_eosy_ac_pkg;

349:
350: END get_parameter;
351:
352:
353: END pay_eosy_ac_pkg;