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.

[Home] [Help]

APPS.PYCADAR_PKG dependencies on PYCADAR_PKG

Line 1: package body pycadar_pkg as

1: package body pycadar_pkg as
2: /* $Header: pycadar.pkb 120.1.12000000.1 2007/01/17 16:51:37 appldev noship $ */
3: /*
4: --
5: rem +======================================================================+

Line 146: ln_assignment_set_id := pycadar_pkg.get_parameter(

142: ld_deposit_start_date,
143: ld_deposit_end_date;
144: close c_get_payroll_action;
145:
146: ln_assignment_set_id := pycadar_pkg.get_parameter(
147: 'ASG_SET_ID',
148: lv_legislative_parameters);
149: ln_payroll_id := pycadar_pkg.get_parameter(
150: 'PAYROLL_ID',

Line 149: ln_payroll_id := pycadar_pkg.get_parameter(

145:
146: ln_assignment_set_id := pycadar_pkg.get_parameter(
147: 'ASG_SET_ID',
148: lv_legislative_parameters);
149: ln_payroll_id := pycadar_pkg.get_parameter(
150: 'PAYROLL_ID',
151: lv_legislative_parameters);
152: ln_consolidation_set_id := pycadar_pkg.get_parameter(
153: 'CONSOLIDATION_SET_ID',

Line 152: ln_consolidation_set_id := pycadar_pkg.get_parameter(

148: lv_legislative_parameters);
149: ln_payroll_id := pycadar_pkg.get_parameter(
150: 'PAYROLL_ID',
151: lv_legislative_parameters);
152: ln_consolidation_set_id := pycadar_pkg.get_parameter(
153: 'CONSOLIDATION_SET_ID',
154: lv_legislative_parameters);
155:
156: p_deposit_start_date := ld_deposit_start_date;

Line 229: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',

225: pay_payroll_actions pa2,
226: pay_payroll_actions pa1,
227: pay_all_payrolls_f ppf
228: where pa1.payroll_action_id = :payroll_action_id
229: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
230: pa1.legislative_parameters)
231: and pa2.consolidation_set_id =
232: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
233: pa1.legislative_parameters)

Line 232: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

228: where pa1.payroll_action_id = :payroll_action_id
229: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
230: pa1.legislative_parameters)
231: and pa2.consolidation_set_id =
232: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
233: pa1.legislative_parameters)
234: and pa2.payroll_id = ppf.payroll_id
235: and pa2.effective_date between
236: pa1.start_date and pa1.effective_date

Line 258: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

254: pay_payroll_actions pa1,
255: pay_all_payrolls_f ppf
256: where pa1.payroll_action_id = :payroll_action_id
257: and pa2.consolidation_set_id =
258: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
259: pa1.legislative_parameters)
260: and pa2.payroll_id = ppf.payroll_id
261: and pa2.effective_date between
262: pa1.start_date and pa1.effective_date

Line 395: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',

391: pay_payroll_actions ppa_mag_pmts,
392: pay_all_payrolls_f ppf
393: where ( ppa_dar.payroll_action_id = pactid
394: and ppa_mag_pmts.consolidation_set_id =
395: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',
396: ppa_dar.legislative_parameters)
397: and ppa_mag_pmts.payroll_id = ppf.payroll_id
398: and ppa_mag_pmts.effective_date between ppa_dar.start_date
399: and ppa_dar.effective_date

Line 411: pycadar_pkg.get_parameter('PAYROLL_ID',

407: paf1.effective_start_date and paf1.effective_end_date
408: and pos.period_of_service_id = paf1.period_of_service_id
409: and pos.person_id between stperson and endperson
410: and (paf1.payroll_id =
411: pycadar_pkg.get_parameter('PAYROLL_ID',
412: ppa_dar.legislative_parameters)
413: or pycadar_pkg.get_parameter('PAYROLL_ID',
414: ppa_dar.legislative_parameters)
415: is null)

Line 413: or pycadar_pkg.get_parameter('PAYROLL_ID',

409: and pos.person_id between stperson and endperson
410: and (paf1.payroll_id =
411: pycadar_pkg.get_parameter('PAYROLL_ID',
412: ppa_dar.legislative_parameters)
413: or pycadar_pkg.get_parameter('PAYROLL_ID',
414: ppa_dar.legislative_parameters)
415: is null)
416: -- No run results.
417: AND NOT EXISTS (SELECT ' '

Line 474: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',ppa_dar.legislative_parameters)

470: and has.assignment_set_id = p_assignment_set_id
471: and ppa_mag.effective_date between
472: ppa_dar.start_date and ppa_dar.effective_date
473: and ppa_mag.consolidation_set_id =
474: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',ppa_dar.legislative_parameters)
475:
476: and (( has.payroll_id is null
477: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
478: nvl(pycadar_pkg.get_parameter('PAYROLL_ID',ppa_dar.legislative_parameters),

Line 478: nvl(pycadar_pkg.get_parameter('PAYROLL_ID',ppa_dar.legislative_parameters),

474: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',ppa_dar.legislative_parameters)
475:
476: and (( has.payroll_id is null
477: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
478: nvl(pycadar_pkg.get_parameter('PAYROLL_ID',ppa_dar.legislative_parameters),
479: nvl(ppa_mag.payroll_id,ppf.payroll_id))
480: ) or
481:
482: nvl(ppa_mag.payroll_id,has.payroll_id) = has.payroll_id

Line 620: NVL(pycadar_pkg.get_parameter(''PAYROLL_ID'',

616: pay_payroll_actions ppa_mag,
617: pay_all_payrolls_f ppf
618: where ppa_dar.payroll_action_id = :pactid
619: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
620: NVL(pycadar_pkg.get_parameter(''PAYROLL_ID'',
621: ppa_dar.legislative_parameters),
622: nvl(ppa_mag.payroll_id,ppf.payroll_id))
623: and nvl(ppa_mag.payroll_id,ppf.payroll_id) = ppf.payroll_id
624: and ppa_mag.effective_date between

Line 628: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

624: and ppa_mag.effective_date between
625: ppf.effective_start_date and ppf.effective_end_date
626: and nvl(ppf.multi_assignments_flag,''N'') = ''N''
627: and ppa_mag.consolidation_set_id + 0 =
628: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
629: ppa_dar.legislative_parameters)
630: and ppa_mag.effective_date between
631: ppa_dar.start_date and ppa_dar.effective_date
632: and act.payroll_action_id = ppa_mag.payroll_action_id

Line 644: and (( paf1.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',

640: paf2.effective_start_date and paf2.effective_end_date
641: and paf2.payroll_id + 0 = paf1.payroll_id + 0
642: and pos.period_of_service_id = paf1.period_of_service_id
643: and pos.person_id between :stperson and :endperson
644: and (( paf1.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
645: ppa_dar.legislative_parameters) )
646: or
647: ( pycadar_pkg.get_parameter(''PAYROLL_ID'',
648: ppa_dar.legislative_parameters) is null )

Line 647: ( pycadar_pkg.get_parameter(''PAYROLL_ID'',

643: and pos.person_id between :stperson and :endperson
644: and (( paf1.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
645: ppa_dar.legislative_parameters) )
646: or
647: ( pycadar_pkg.get_parameter(''PAYROLL_ID'',
648: ppa_dar.legislative_parameters) is null )
649: )
650: and not exists
651: (

Line 903: and pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',

899: and cp_deposit_end_date between ppa_pyarch.start_date
900: and ppa_pyarch.effective_date
901: and cp_deposit_end_date between paf.effective_start_date
902: and paf.effective_end_date
903: and pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',
904: ppa_pyarch.legislative_parameters)
905: = cp_consolidation_set_id
906: and paa_pyarch.payroll_action_id = ppa_pyarch.payroll_action_id
907: -- the statement below will make sure only Pre Payment Archive

Line 916: pycadar_pkg.get_parameter('PAYROLL_ID',

912: and paf.effective_end_date
913: and pai_pre.locking_Action_id = paa_pyarch.assignment_action_id
914: and (cp_payroll_id is null
915: or
916: pycadar_pkg.get_parameter('PAYROLL_ID',
917: ppa_pyarch.legislative_parameters)
918: = cp_payroll_id
919: )
920: and paf.person_id between cp_start_person and cp_end_person

Line 926: and pycadar_pkg.check_if_assignment_paid(

922: 'PAYSLIP','PRINT',
923: 'ASSIGNMENT',paf.assignment_id,
924: cp_deposit_end_date
925: ) = 'Y'
926: and pycadar_pkg.check_if_assignment_paid(
927: pai_pre.locked_action_id,
928: cp_deposit_start_date,
929: cp_deposit_end_date,
930: cp_consolidation_set_id) = 'Y'

Line 1148: end pycadar_pkg;

1144:
1145: return l_label_meaning;
1146: end get_labels;
1147:
1148: end pycadar_pkg;