1 PACKAGE GHR_APPROVED_PA_REQUESTS AUTHID CURRENT_USER AS
2 /* $Header: ghparapr.pkh 120.0.12010000.4 2009/02/01 10:49:41 vmididho ship $ */
3 --
4 --
5 --
6 --
7 -- ------------------------------------------------
8 function ghr_correct_sf52 (
9 -- ------------------------------------------------
10 p_pa_request_id in number
11 , p_par_object_version_number IN number
12 , p_noa_id in number
13 , p_which_noa in number
14 , p_row_id in varchar
15 , p_username in varchar)
16 return number;
17 --
18 -- ------------------------------------------------
19 function ghr_cancel_sf52 (
20 -- ------------------------------------------------
21 p_pa_request_id in number
22 , p_par_object_version_number IN OUT NOCOPY number
23 , p_noa_id in number
24 , p_which_noa in number
25 , p_row_id in varchar2
26 , p_username in varchar2
27 , p_which_action in varchar2 default 'SUBSEQUENT'
28 , p_cancel_legal_authority in varchar2)
29 return number;
30 --
31 -- ------------------------------------------------
32 function ghr_reroute_sf52 (
33 -- ------------------------------------------------
34 P_PA_REQUEST_ID IN NUMBER
35 ,p_par_object_version_number IN OUT NOCOPY number
36 ,P_ROUTING_GROUP_ID IN NUMBER
37 ,P_USER_NAME IN VARCHAR2
38 )
39 return boolean;
40
41 -- ---------------------------------
42 PROCEDURE find_last_request(
43 -- ---------------------------------
44 p_pa_request_id in number
45 , p_which_noa in number
46 , p_row_id in varchar
47 , p_first_pa_request_rec IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE
48 , p_last_pa_request_rec IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE
49 , p_number_of_requests IN OUT NOCOPY number
50 );
51
52 -- ---------------------------------
53 PROCEDURE can_cancel_or_correct(
54 -- ---------------------------------
55 p_pa_request_id in number
56 , p_which_noa in number
57 , p_row_id in varchar
58 , p_total_actions IN OUT NOCOPY number
59 , p_corrections IN OUT NOCOPY number
60 , p_rpas IN OUT NOCOPY number
61 );
62 -- BUG # 7216635 added the new parameter p_noa_id_correct
63 -- ------------------------------------------------
64 FUNCTION chk_intervene_seq (
65 -- ------------------------------------------------
66 p_pa_request_id in number
67 , p_pa_notification_id in number
68 , p_person_id in number
69 , p_effective_date in date
70 , p_noa_id_correct in number)
71 return NUMBER;
72 -- BUG # 7216635 added the new parameter p_noa_id_correct
73 -- ------------------------------------------------
74 PROCEDURE determine_ia (
75 -- ------------------------------------------------
76 p_pa_request_id in number
77 , p_pa_notification_id in number
78 , p_person_id in number
79 , p_effective_date in date
80 , p_noa_id_correct in number
81 , p_retro_pa_request_id out nocopy number
82 , p_retro_eff_date out nocopy date
83 , p_retro_first_noa out nocopy varchar2
84 , p_retro_second_noa out nocopy varchar2
85 ) ;
86
87 --
88 --6850492
89 procedure Update_Dual_Id(p_parent_pa_request_id in number,
90 p_first_dual_action_id in number,
91 p_second_dual_action_id in number);
92
93 --6850492
94
95 end GHR_APPROVED_PA_REQUESTS ;