DBA Data[Home] [Help]

PACKAGE: APPS.PQH_AME_UTILS

Source


1 PACKAGE pqh_ame_utils AS
2 /* $Header: pqameutl.pkh 120.0 2005/05/29 01:24:17 appldev noship $ */
3 --
4 --
5 g_item_type       hr_api_transactions.item_Type%Type;
6 g_item_key        hr_api_transactions.item_Key%Type;
7 g_process_name    hr_api_transactions.process_name%Type;
8 g_person_id       number(18);
9 g_creator_person_id number(18);
10 g_transaction_id  number(18);
11 g_function_id     number(18);
12    function get_item_type( p_transaction_id in varchar2) return varchar2;
13    function get_item_key( p_transaction_id in varchar2) return varchar2;
14    function get_process_name( p_transaction_id in varchar2) return varchar2;
15    function get_final_approver( p_transaction_id in varchar2) return varchar2;
16    function get_requestor_person_id( p_transaction_id in varchar2) return varchar2;
17 END; -- Package Specification PQH_AME_UTILS