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 257: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);

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

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

255: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);
256: l_person_id :=
257: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
258: l_assignment_set_id :=
259: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
260: l_assignment_amend :=
261: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
262:
263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));

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

257: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
258: l_assignment_set_id :=
259: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
260: l_assignment_amend :=
261: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
262:
263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));
264: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
265: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));

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

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

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

1197: l_business_group_id;
1198: close cur_payroll_actions;
1199:
1200: l_person_id :=
1201: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1202: l_assignment_set_id :=
1203: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1204: l_assignment_amend :=
1205: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

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

1199:
1200: l_person_id :=
1201: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1202: l_assignment_set_id :=
1203: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1204: l_assignment_amend :=
1205: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1206: l_end_date := l_effective_date;
1207:

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

1201: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
1202: l_assignment_set_id :=
1203: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
1204: l_assignment_amend :=
1205: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1206: l_end_date := l_effective_date;
1207:
1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));

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

2183: l_t4a_gre;
2184: close cur_archive_info;
2185:
2186: l_person_id :=
2187: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2188: l_assignment_set_id :=
2189: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2190: l_assignment_amend :=
2191: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);

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

2185:
2186: l_person_id :=
2187: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2188: l_assignment_set_id :=
2189: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2190: l_assignment_amend :=
2191: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
2192:
2193: if l_assignment_set_id is not null then

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

2187: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
2188: l_assignment_set_id :=
2189: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
2190: l_assignment_amend :=
2191: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
2192:
2193: if l_assignment_set_id is not null then
2194:
2195: open cur_person_id(p_assactid);