PACKAGE: APPS.PQH_PROCESS_EMP_REVIEW

Source

1 PACKAGE pqh_process_emp_review AUTHID CURRENT_USER AS
2 /* $Header: pqrewpkg.pkh 115.6 2004/05/11 15:08:18 nsanghal noship $ */
3 --
4 --
5 --
6 TYPE ref_cursor IS REF CURSOR;
7 --
8 FUNCTION  get_reviewers (
9    p_transaction_step_id in varchar2
10   ,p_show_deleted        in varchar2 default NULL ) RETURN ref_cursor;
11 --
12 --
13 --
14 FUNCTION  get_employee_review (
15  p_transaction_step_id   in     varchar2 ) RETURN ref_cursor ;
16 --
17 --
18 
19 PROCEDURE get_emp_review_details(
20  x_transaction_step_id      IN  VARCHAR2,
21  x_Event_Id                 OUT NOCOPY NUMBER,
22  x_Assignment_Id            OUT NOCOPY NUMBER,
23  x_Type                     OUT NOCOPY VARCHAR2,
24  x_Date_Start               OUT NOCOPY VARCHAR2,
25  x_Date_End                 OUT NOCOPY VARCHAR2,
26  x_Time_Start               OUT NOCOPY VARCHAR2,
27  x_Time_End                 OUT NOCOPY VARCHAR2,
28  x_Location_Id              OUT NOCOPY NUMBER,
29  x_Comments                 OUT NOCOPY VARCHAR2,
30  x_Business_Group_Id        OUT NOCOPY NUMBER ,
31  x_notify_flag		   OUT NOCOPY   VARCHAR2
32 );
33 --
34 --
35 
36 PROCEDURE get_emp_reviewers_details(
37 x_transaction_step_id      IN    VARCHAR2,
38 x_Event_Id                 OUT NOCOPY   NUMBER,
39 x_Booking_Id               OUT NOCOPY   NUMBER,
40 x_Employee_no              OUT NOCOPY   VARCHAR2,
41 x_Comments                 OUT NOCOPY   VARCHAR2,
42 x_Business_Group_Id        OUT NOCOPY   NUMBER,
43 x_status                   OUT NOCOPY   VARCHAR2,
44 x_row_number		   IN    VARCHAR2,
45 x_person_id		   OUT NOCOPY   NUMBER   );
46 
47 
48 --
49 --
50 
51 PROCEDURE get_reviewers_count(
52 x_transaction_step_id      IN    VARCHAR2,
53 
54 x_total_no_of_rows   OUT NOCOPY NUMBER,
55  x_total_deleted_rows   OUT NOCOPY NUMBER);
56 --
57 --
58 
59 
60 PROCEDURE set_emp_review_details(
61 x_Login_person_id          IN 	NUMBER,
62 x_Person_id                IN 	NUMBER,
63 x_Item_type                IN 	VARCHAR2,
64 x_Item_key                 IN 	NUMBER,
65 x_Activity_id              IN 	NUMBER,
66 x_Event_Id                 IN   NUMBER,
67 x_Assignment_Id            IN   NUMBER,
68 x_Type                     IN   VARCHAR2,
69 x_Date_Start               IN   VARCHAR2,
70 x_Date_End                 IN   VARCHAR2,
71 x_Time_Start               IN   VARCHAR2,
72 x_Time_End                 IN   VARCHAR2,
73 x_Location_Id              IN   NUMBER,
74 x_Comments                 IN   VARCHAR2,
75 x_Business_Group_Id        IN   NUMBER,
76 x_notify_flag		   IN   VARCHAR2);
77 --
78 --
79 
80 PROCEDURE set_emp_reviewer_details(
81 x_login_person_id          IN 	NUMBER,
82 x_person_id                IN 	NUMBER,
83 x_item_type                IN 	VARCHAR2,
84 x_item_key                 IN 	NUMBER,
85 x_activity_id              IN 	NUMBER,
86 x_Event_Id                 IN   NUMBER,
87 x_Booking_Id               IN   NUMBER,
88 x_Employee_no              IN   VARCHAR2,
89 x_Comments                 IN   VARCHAR2,
90 x_Business_Group_Id        IN   NUMBER,
91 x_row_number		   IN   VARCHAR2,
92 x_status                   IN   VARCHAR2) ;
93 
94 --
95 --
96 
97 PROCEDURE process_api (
98    p_validate		   IN   BOOLEAN DEFAULT FALSE,
99    p_transaction_step_id   IN   NUMBER );
100 --
101 --
102 PROCEDURE process_emp_reviewers_api (
103      p_validate             IN   BOOLEAN DEFAULT FALSE,
104      p_Event_Id             IN   NUMBER,
105      p_Booking_Id           IN   NUMBER,
106      p_Employee_no          IN   VARCHAR2 ,
107      p_Comments             IN   VARCHAR2 ,
108      p_Business_Group_Id    IN   NUMBER,
109      p_status               IN   VARCHAR2,
110      p_personId             IN   NUMBER     ) ;
111 --
112 --
113 
114 PROCEDURE rollback_transaction (
115 	itemType	IN VARCHAR2,
116 	itemKey		IN VARCHAR2,
117         result	 OUT NOCOPY VARCHAR2) ;
118 
119 --
120 --
121 pkg_event_id Number;
122 END pqh_process_emp_review;