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_PAYROLL_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1: PACKAGE BODY PAY_PAYROLL_ACTIONS_PKG AS

1: PACKAGE BODY PAY_PAYROLL_ACTIONS_PKG AS
2: /* $Header: pypra02t.pkb 120.8.12010000.2 2008/08/06 08:14:26 ubhat ship $
3: --
4: PRODUCT
5: Oracle*Payroll

Line 76: pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE')

72: cursor.
73: alogue 115.31 28-MAR-2007 Support for single latest balance table in
74: latest_balance_exists. Bug 5956216.
75: alogue 115.32 26-JUL-2007 Bug 6130796 - check within v_name procedure
76: pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE')
77: is same as action_type passed in.
78: mshingan 115.33 21-AUG-2007 Bug 6353676 - Translated element set name is used.
79: Cursor get_element_set_name is using pay_element_sets_tl
80: instead of pay_element_sets.

Line 119: update PAY_PAYROLL_ACTIONS

115: procedure update_row(p_rowid in varchar2,
116: p_action_status in varchar2 ) is
117: begin
118: --
119: update PAY_PAYROLL_ACTIONS
120: set ACTION_STATUS = p_action_status
121: where ROWID = p_rowid;
122: --
123: end update_row;

Line 130: delete from PAY_PAYROLL_ACTIONS

126: procedure delete_row(p_rowid in varchar2) is
127: --
128: begin
129: --
130: delete from PAY_PAYROLL_ACTIONS
131: where ROWID = p_rowid;
132: --
133: end delete_row;
134: --

Line 141: from PAY_PAYROLL_ACTIONS

137: p_action_status in varchar2 ) is
138: --
139: --
140: cursor C is select *
141: from PAY_PAYROLL_ACTIONS
142: where rowid = p_rowid
143: for update of PAYROLL_ACTION_ID NOWAIT ;
144: --
145: rowinfo C%rowtype;

Line 296: l_report_type pay_payroll_actions.report_type%type;

292: l_element_name pay_element_types_f_tl.element_name%type;
293: l_asset hr_assignment_sets.assignment_set_name%type ;
294: l_eltset pay_element_sets_tl.element_set_name%type ;
295: l_dummy number ;
296: l_report_type pay_payroll_actions.report_type%type;
297:
298: --bug no. 3665606
299: l_element_type_id pay_payroll_actions.element_type_id%type;
300: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

Line 299: l_element_type_id pay_payroll_actions.element_type_id%type;

295: l_dummy number ;
296: l_report_type pay_payroll_actions.report_type%type;
297:
298: --bug no. 3665606
299: l_element_type_id pay_payroll_actions.element_type_id%type;
300: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
301:
302:
303: cursor get_consolidation_set is

Line 300: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

296: l_report_type pay_payroll_actions.report_type%type;
297:
298: --bug no. 3665606
299: l_element_type_id pay_payroll_actions.element_type_id%type;
300: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
301:
302:
303: cursor get_consolidation_set is
304: select consolidation_set_name

Line 329: from pay_payroll_actions ppa

325: where ast.assignment_set_id = p_assignment_set_id;
326: --
327: cursor get_purge_phase is
328: select hr_general.decode_lookup('PURGE_PHASE', to_char(ppa.purge_phase))
329: from pay_payroll_actions ppa
330: where ppa.payroll_action_id = p_payroll_action_id;
331: --
332: cursor get_person_name is
333: select /*+ INDEX

Line 342: pay_payroll_actions pac,

338: peo.full_name
339: ,pac.element_type_id --bug no. 3665606
340: ,pac.legislative_parameters --bug no. 3665606
341: from pay_assignment_actions aac,
342: pay_payroll_actions pac,
343: per_all_people_f peo,
344: per_all_assignments_f asg
345: where pac.payroll_action_id = p_payroll_action_id
346: and aac.payroll_action_id = pac.payroll_action_id

Line 360: from pay_payroll_actions pac,

356: select /*+ ORDERED
357: INDEX(rrs PAY_RUN_RESULTS_N50)
358: USE_NL(rrs)*/
359: tl.element_name
360: from pay_payroll_actions pac,
361: pay_assignment_actions aac,
362: pay_run_results rrs,
363: pay_element_types_f ety,
364: pay_element_types_f_tl tl

Line 377: select /+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) /

373: -- Get the archive details for the SQWL
374: -- Note that this has some US specific coding.
375: --
376: cursor get_archiver is
377: select /*+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) */
378: pus.state_name||'-'||pac.report_type||decode(hou.name,
379: NULL, NULL, '-'||hou.name)
380: from pay_us_states pus,
381: hr_organization_units hou,

Line 382: pay_payroll_actions pac,

378: pus.state_name||'-'||pac.report_type||decode(hou.name,
379: NULL, NULL, '-'||hou.name)
380: from pay_us_states pus,
381: hr_organization_units hou,
382: pay_payroll_actions pac,
383: per_business_groups_perf bg
384: where pac.payroll_action_id = p_payroll_action_id
385: and pac.report_qualifier = pus.state_abbrev
386: and pac.report_category is not null

Line 399: select /+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) /

395: -- instr(pac.legislative_parameters,
396: -- 'TRANSFER_GRE') + 13)
397: -- )
398: union
399: select /*+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) */
400: 'Federal-'||pac.report_type||decode(hou.name,
401: NULL, NULL, '-'||hou.name)
402: from hr_all_organization_units hou,
403: pay_payroll_actions pac

Line 403: pay_payroll_actions pac

399: select /*+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) */
400: 'Federal-'||pac.report_type||decode(hou.name,
401: NULL, NULL, '-'||hou.name)
402: from hr_all_organization_units hou,
403: pay_payroll_actions pac
404: where pac.payroll_action_id = p_payroll_action_id
405: and pac.report_category is not null
406: and pac.report_qualifier = 'FED'
407: and hou.organization_id(+) = pay_core_utils.get_parameter('TRANSFER_GRE',pac.legislative_parameters);

Line 422: pay_payroll_actions pac

418: cursor get_archiver_gu is
419: -- derives the process names for Generic Upgrade Archiver Processes.
420: select pud.name
421: from pay_upgrade_definitions_vl pud,
422: pay_payroll_actions pac
423: where pac.payroll_action_id = p_payroll_action_id
424: and pud.short_name = pay_core_utils.get_parameter('UPG_DEF_NAME',pac.legislative_parameters);
425:
426: cursor get_report_type is

Line 428: from pay_payroll_actions pac

424: and pud.short_name = pay_core_utils.get_parameter('UPG_DEF_NAME',pac.legislative_parameters);
425:
426: cursor get_report_type is
427: select pac.report_type
428: from pay_payroll_actions pac
429: where pac.payroll_action_id = p_payroll_action_id;
430:
431:
432: cursor get_archiver_others is

Line 434: from pay_payroll_actions pac,

430:
431:
432: cursor get_archiver_others is
433: select rfmtl.display_name
434: from pay_payroll_actions pac,
435: pay_report_format_mappings_f rfm,
436: pay_report_format_mappings_tl rfmtl
437: where pac.payroll_action_id = p_payroll_action_id
438: and pac.report_type = rfm.report_type

Line 453: from pay_payroll_actions pacc,

449: --
450: cursor get_void_chq is
451: select fnd_date.date_to_canonical(pacc.effective_date)||'-'||to_char(pacv.start_cheque_number)
452: ||'-'||to_char(pacv.end_cheque_number)
453: from pay_payroll_actions pacc,
454: pay_payroll_actions pacv
455: where pacv.payroll_action_id = p_payroll_action_id
456: and pacc.payroll_action_id = pacv.target_payroll_action_id ;
457: --

Line 454: pay_payroll_actions pacv

450: cursor get_void_chq is
451: select fnd_date.date_to_canonical(pacc.effective_date)||'-'||to_char(pacv.start_cheque_number)
452: ||'-'||to_char(pacv.end_cheque_number)
453: from pay_payroll_actions pacc,
454: pay_payroll_actions pacv
455: where pacv.payroll_action_id = p_payroll_action_id
456: and pacc.payroll_action_id = pacv.target_payroll_action_id ;
457: --
458: cursor batch_names is

Line 461: pay_payroll_actions ppa

457: --
458: cursor batch_names is
459: select pbh.batch_name
460: from pay_batch_headers pbh,
461: pay_payroll_actions ppa
462: where ppa.batch_id = pbh.batch_id
463: and ppa.payroll_action_id = p_payroll_action_id;
464: --
465: begin

Line 474: if pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') is not null then

470: if (not p_force) and (not g_server_validate) then
471: RETURN NULL;
472: end if;
473: --
474: if pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') is not null then
475: if ( p_action_type <> pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') ) then
476: RETURN NULL;
477: end if;
478: end if;

Line 475: if ( p_action_type <> pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') ) then

471: RETURN NULL;
472: end if;
473: --
474: if pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') is not null then
475: if ( p_action_type <> pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE') ) then
476: RETURN NULL;
477: end if;
478: end if;
479: --

Line 629: hr_utility.trace( 'pay_payroll_actions_pkg.set_query_bindvar : '

625: procedure set_query_bindvar( p_context_name in varchar2,
626: p_context_value in varchar2 ) is
627: begin
628:
629: hr_utility.trace( 'pay_payroll_actions_pkg.set_query_bindvar : '
630: ||p_context_name||'='||p_context_value);
631:
632: if ( upper(p_context_name) = 'BUSINESS_GROUP_ID' )
633: then

Line 651: invalid_argument('pay_payroll_actions_pkg.set_query_bindvar',p_context_value);

647: elsif ( upper(p_context_name) = 'SERVER_VALIDATE')
648: then
649: g_server_validate := (p_context_value='Y');
650: else
651: invalid_argument('pay_payroll_actions_pkg.set_query_bindvar',p_context_value);
652: end if;
653:
654: end set_query_bindvar ;
655: -----------------------------------------------------------------------------------

Line 666: invalid_argument('pay_payroll_actions_pkg.get_num_bindvar',p_context_name);

662: elsif ( upper(p_context_name) = 'PAYROLL_ID' )
663: then
664: l_return_value := g_payroll_id ;
665: else
666: invalid_argument('pay_payroll_actions_pkg.get_num_bindvar',p_context_name);
667: end if;
668:
669: return (l_return_value) ;
670:

Line 689: invalid_argument('pay_payroll_actions_pkg.get_char_bindvar',p_context_name);

685: else
686: l_return_value :='N';
687: end if;
688: else
689: invalid_argument('pay_payroll_actions_pkg.get_char_bindvar',p_context_name);
690: end if;
691: return (l_return_value) ;
692: --
693: end get_char_bindvar;

Line 706: invalid_argument('pay_payroll_actions_pkg.get_date_bindvar',p_context_name);

702: elsif ( upper(p_context_name) = 'PERIOD_DATE_TO' )
703: then
704: l_return_value := g_period_date_to ;
705: else
706: invalid_argument('pay_payroll_actions_pkg.get_date_bindvar',p_context_name);
707: end if;
708:
709: return (l_return_value) ;
710:

Line 842: END PAY_PAYROLL_ACTIONS_PKG;

838: return l_cheque_type;
839: --
840: end decode_cheque_type;
841: ---------------------------------------------------------------------
842: END PAY_PAYROLL_ACTIONS_PKG;