PACKAGE: APPS.PQH_PROCESS_ACADEMIC_RANK

Source

1 PACKAGE pqh_process_academic_rank AS
2 /* $Header: pqhusark.pkh 120.1 2006/07/18 19:42:13 nsanghal noship $*/
3 --
4 --
5 TYPE ref_cursor IS REF CURSOR;
6 --
7 FUNCTION  get_academic_rank (
8  p_transaction_step_id   in     varchar2 ) RETURN ref_cursor ;
9 --
10 --
11 
12 PROCEDURE  get_academic_rank_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_person_extra_info_id out nocopy varchar2 );
20 
21 PROCEDURE set_academic_rank_details (
22   x_login_person_id     IN NUMBER,
23   x_person_id     	IN NUMBER,
24   x_item_type           IN VARCHAR2,
25   x_item_key            IN NUMBER,
26   x_activity_id         IN NUMBER,
27   x_object_version_number IN NUMBER,
28   x_person_extra_info_id IN NUMBER,
29   x_pei_information1	IN VARCHAR2,
30   x_pei_information2	IN VARCHAR2,
31   x_pei_information3	IN VARCHAR2,
32   x_pei_information4	IN VARCHAR2,
33   x_pei_information5	IN VARCHAR2 );
34 
35 PROCEDURE process_api (
36    p_validate			IN BOOLEAN DEFAULT FALSE,
37    p_transaction_step_id	IN NUMBER,
38    p_effective_date             IN VARCHAR2 DEFAULT NULL );
39 
40 END;