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
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.
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;
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: --
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
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: -----------------------------------------------------------------------------------
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:
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;
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:
839: return l_cheque_type;
840: --
841: end decode_cheque_type;
842: ---------------------------------------------------------------------
843: END PAY_PAYROLL_ACTIONS_PKG;