DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS_PKG

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 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;