PACKAGE: APPS.PQH_PROCESS_TENURE_STATUS

Source

1 PACKAGE pqh_process_tenure_status AUTHID CURRENT_USER AS
2 /* $Header: pqhusten.pkh 115.6 2004/02/11 12:12:18 nsanghal noship $*/
3 --
4 --
5 TYPE ref_cursor IS REF CURSOR;
6 --
7 FUNCTION  get_tenure_status  (
8  p_transaction_step_id   in     varchar2 ) RETURN ref_cursor ;
9 --
10 --
11 
12 PROCEDURE  get_tenure_details (
13  x_transaction_step_id   in     varchar2
14 ,x_pei_information1 out nocopy varchar2
15 ,x_pei_information2 out nocopy varchar2
16 ,x_pei_information3 out nocopy varchar2
17 ,x_pei_information4 out nocopy varchar2
18 ,x_pei_information5 out nocopy varchar2
19 ,x_pei_information6 out nocopy varchar2
20 ,x_person_extra_info_id out nocopy varchar2 );
21 --
22 --
23 PROCEDURE set_tenure_details (
24   x_login_person_id     IN NUMBER,
25   x_person_id           IN NUMBER,
26   x_item_type           IN VARCHAR2,
27   x_item_key            IN NUMBER,
28   x_activity_id         IN NUMBER,
29   x_object_version_number IN NUMBER,
30   x_person_extra_info_id IN NUMBER,
31   x_pei_information1	IN VARCHAR2,
32   x_pei_information2	IN VARCHAR2,
33   x_pei_information3	IN VARCHAR2,
34   x_pei_information4	IN VARCHAR2,
35   x_pei_information5	IN VARCHAR2,
36   x_pei_information6	IN VARCHAR2 );
37 --
38 --
39 PROCEDURE process_api (
40    p_validate			IN BOOLEAN DEFAULT FALSE,
41    p_transaction_step_id	IN NUMBER );
42 --
43 --
44 PROCEDURE rollback_transaction (
45 	itemType	IN VARCHAR2,
46 	itemKey		IN VARCHAR2,
47         result	 OUT NOCOPY VARCHAR2) ;
48 --
49 --
50 PROCEDURE self_or_subordinate (
51 	itemtype   	IN VARCHAR2,
52         itemkey    	IN VARCHAR2,
53         actid      	IN NUMBER,
54         funcmode   	IN VARCHAR2,
55         resultout  	IN OUT NOCOPY VARCHAR2);
56 --
57 --
58 END pqh_process_tenure_status;