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.10 2011/08/26 08:26:17 ranarra noship $
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 378: select /+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) /

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

Line 383: pay_payroll_actions pac,

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

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

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

Line 404: pay_payroll_actions pac

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

Line 423: pay_payroll_actions pac

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

Line 429: from pay_payroll_actions pac

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

Line 435: from pay_payroll_actions pac,

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

Line 454: from pay_payroll_actions pacc,

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

Line 455: pay_payroll_actions pacv

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

Line 462: pay_payroll_actions ppa

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 843: END PAY_PAYROLL_ACTIONS_PKG;

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