eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_ARCHIVE dependencies on PYCADAR_PKG

Line 253: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);

249: close cur_payroll_actions;
250:
251: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);
252: l_person_id :=
253: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
254: l_assignment_set_id :=
255: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
256: l_assignment_amend :=
257: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

Line 255: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);

251: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);
252: l_person_id :=
253: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
254: l_assignment_set_id :=
255: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
256: l_assignment_amend :=
257: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
258:
259: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));

Line 257: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

253: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
254: l_assignment_set_id :=
255: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
256: l_assignment_amend :=
257: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
258:
259: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));
260: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
261: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));

Line 273: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and

269: per_assignments_f paf,
270: pay_payroll_actions ppa
271: WHERE
272: hasa.assignment_set_id =
273: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
274: hasa.include_or_exclude = ''I'' and
275: hasa.assignment_id = paf.assignment_id and
276: ppa.payroll_action_id = :pactid
277: ORDER BY paf.person_id';

Line 1197: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);

1193: l_business_group_id;
1194: close cur_payroll_actions;
1195:
1196: l_person_id :=
1197: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1198: l_assignment_set_id :=
1199: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1200: l_assignment_amend :=
1201: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

Line 1199: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);

1195:
1196: l_person_id :=
1197: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1198: l_assignment_set_id :=
1199: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1200: l_assignment_amend :=
1201: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1202: l_end_date := l_effective_date;
1203:

Line 1201: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

1197: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1198: l_assignment_set_id :=
1199: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1200: l_assignment_amend :=
1201: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1202: l_end_date := l_effective_date;
1203:
1204: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1205: hr_utility.trace('Person ID = '|| to_char(l_person_id));

Line 2183: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);

2179: l_t4a_gre;
2180: close cur_archive_info;
2181:
2182: l_person_id :=
2183: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2184: l_assignment_set_id :=
2185: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2186: l_assignment_amend :=
2187: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

Line 2185: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);

2181:
2182: l_person_id :=
2183: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2184: l_assignment_set_id :=
2185: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2186: l_assignment_amend :=
2187: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
2188:
2189: if l_assignment_set_id is not null then

Line 2187: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

2183: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2184: l_assignment_set_id :=
2185: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2186: l_assignment_amend :=
2187: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
2188:
2189: if l_assignment_set_id is not null then
2190:
2191: open cur_person_id(p_assactid);