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