[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_ROUTE_PEOPLE_UTIL
Source
1 PACKAGE Eng_Change_Route_People_Util AS
2 /* $Header: ENGURTPS.pls 120.0 2005/05/26 18:56:52 appldev noship $ */
3
4 --
5 -- Constant Variables :
6 --
7 -- Here
8
9 /********************************************************************
10 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
11 * Write_Debug
12 * Parameters IN :
13 * Parameters OUT:
14 * Purpose : These PROCEDUREs are for test and debug
15 *********************************************************************/
16 -- Open_Debug_Session
17 PROCEDURE Open_Debug_Session
18 ( p_output_dir IN VARCHAR2 := NULL
19 , p_file_name IN VARCHAR2 := NULL
20 );
21
22 -- Close Debug_Session
23 PROCEDURE Close_Debug_Session ;
24
25 -- Write Debug Message
26 PROCEDURE Write_Debug
27 ( p_debug_message IN VARCHAR2 ) ;
28
29
30 /********************************************************************
31 * API Type : Private APIs
32 * Purpose : Those APIs are private
33 *********************************************************************/
34
35 -- Change Route Assignee Record
36 TYPE Assignee_Rec_Type IS RECORD
37 (
38 assignee_id NUMBER
39 ,assignee_type_code VARCHAR2(30)
40 ,assignee_type VARCHAR2(30)
41 ,assignee_name VARCHAR2(360)
42 ,assignee_company VARCHAR2(360)
43 ,assignee_role_obj_name VARCHAR2(240)
44 ) ;
45
46
47 TYPE Assignee_Tbl_Type IS TABLE OF Assignee_Rec_Type
48 INDEX BY BINARY_INTEGER ;
49
50 G_ASSIGNEE_TBL Eng_Change_Route_People_Util.Assignee_Tbl_Type ;
51
52 FUNCTION Get_Assignee_Name
53 ( p_assignee_id IN NUMBER
54 , p_assignee_type_code IN VARCHAR2
55 , p_current_flag IN VARCHAR2 := NULL
56 )
57 RETURN VARCHAR2 ;
58
59
60
61 FUNCTION Get_Assignee_Company
62 ( p_assignee_id IN NUMBER
63 , p_assignee_type_code IN VARCHAR2
64 , p_current_flag IN VARCHAR2 := NULL
65 )
66 RETURN VARCHAR2 ;
67
68
69 FUNCTION Get_Assignee_Type
70 ( p_assignee_id IN NUMBER
71 , p_assignee_type_code IN VARCHAR2
72 , p_current_flag IN VARCHAR2 := NULL
73 )
74 RETURN VARCHAR2 ;
75
76
77
78
79
80 /********************************************************************
81 * API Type : Private Copy People API
82 * Purpose : This api will copy instances for Route People
83 *********************************************************************/
84 PROCEDURE COPY_PEOPLE (
85 P_FROM_STEP_ID IN NUMBER ,
86 P_TO_STEP_ID IN NUMBER ,
87 P_USER_ID IN NUMBER := NULL ,
88 P_API_CALLER IN VARCHAR2 := NULL
89 ) ;
90
91
92
93 /********************************************************************
94 * API Type : Private Table Hander APIs
95 * Purpose : Those APIs are private
96 * Table Hander for TL Entity Object:
97 * ENG_CHANGE_ROUTE_PEOPLE_VL
98 * PROCEDURE INSERT_ROW;
99 * PROCEDURE LOCK_ROW;
100 * PROCEDURE UPDATE_ROW;
101 * PROCEDURE DELETE_ROW;
102 *********************************************************************/
103 PROCEDURE INSERT_ROW (
104 X_ROWID IN OUT NOCOPY VARCHAR2,
105 X_ROUTE_PEOPLE_ID IN NUMBER,
106 X_STEP_ID IN NUMBER,
107 X_ASSIGNEE_ID IN NUMBER,
108 X_ASSIGNEE_TYPE_CODE IN VARCHAR2,
109 X_ADHOC_PEOPLE_FLAG IN VARCHAR2,
110 X_WF_NOTIFICATION_ID IN NUMBER,
111 X_RESPONSE_CODE IN VARCHAR2,
112 X_RESPONSE_DATE IN DATE,
113 X_REQUEST_ID IN NUMBER,
114 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
115 X_RESPONSE_DESCRIPTION IN VARCHAR2,
116 X_CREATION_DATE IN DATE,
117 X_CREATED_BY IN NUMBER,
118 X_LAST_UPDATE_DATE IN DATE,
119 X_LAST_UPDATED_BY IN NUMBER,
120 X_LAST_UPDATE_LOGIN IN NUMBER,
121 X_PROGRAM_ID IN NUMBER,
122 X_PROGRAM_APPLICATION_ID IN NUMBER,
123 X_PROGRAM_UPDATE_DATE IN DATE,
124 X_ORIGINAL_ASSIGNEE_ID IN NUMBER,
125 X_ORIGINAL_ASSIGNEE_TYPE_CODE IN VARCHAR2,
126 X_RESPONSE_CONDITION_CODE IN VARCHAR2,
127 X_PARENT_ROUTE_PEOPLE_ID IN NUMBER
128 );
129
130
131 PROCEDURE LOCK_ROW (
132 X_ROUTE_PEOPLE_ID IN NUMBER,
133 X_STEP_ID IN NUMBER,
134 X_ASSIGNEE_ID IN NUMBER,
135 X_ASSIGNEE_TYPE_CODE IN VARCHAR2,
136 X_ADHOC_PEOPLE_FLAG IN VARCHAR2,
137 X_WF_NOTIFICATION_ID IN NUMBER,
138 X_RESPONSE_CODE IN VARCHAR2,
139 X_RESPONSE_DATE IN DATE,
140 X_REQUEST_ID IN NUMBER,
141 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
142 X_RESPONSE_DESCRIPTION IN VARCHAR2,
143 X_PROGRAM_ID IN NUMBER,
144 X_PROGRAM_APPLICATION_ID IN NUMBER,
145 X_PROGRAM_UPDATE_DATE IN DATE,
146 X_ORIGINAL_ASSIGNEE_ID IN NUMBER,
147 X_ORIGINAL_ASSIGNEE_TYPE_CODE IN VARCHAR2,
148 X_RESPONSE_CONDITION_CODE IN VARCHAR2,
149 X_PARENT_ROUTE_PEOPLE_ID IN NUMBER
150 );
151
152
153 PROCEDURE UPDATE_ROW (
154 X_ROUTE_PEOPLE_ID IN NUMBER,
155 X_STEP_ID IN NUMBER,
156 X_ASSIGNEE_ID IN NUMBER,
157 X_ASSIGNEE_TYPE_CODE IN VARCHAR2,
158 X_ADHOC_PEOPLE_FLAG IN VARCHAR2,
159 X_WF_NOTIFICATION_ID IN NUMBER,
160 X_RESPONSE_CODE IN VARCHAR2,
161 X_RESPONSE_DATE IN DATE,
162 X_REQUEST_ID IN NUMBER,
163 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
164 X_RESPONSE_DESCRIPTION IN VARCHAR2,
165 X_LAST_UPDATE_DATE IN DATE,
166 X_LAST_UPDATED_BY IN NUMBER,
167 X_LAST_UPDATE_LOGIN IN NUMBER,
168 X_PROGRAM_ID IN NUMBER,
169 X_PROGRAM_APPLICATION_ID IN NUMBER,
170 X_PROGRAM_UPDATE_DATE IN DATE,
171 X_ORIGINAL_ASSIGNEE_ID IN NUMBER,
172 X_ORIGINAL_ASSIGNEE_TYPE_CODE IN VARCHAR2,
173 X_RESPONSE_CONDITION_CODE IN VARCHAR2,
174 X_PARENT_ROUTE_PEOPLE_ID IN NUMBER
175
176 );
177
178
179
180 PROCEDURE DELETE_ROW (
181 X_ROUTE_PEOPLE_ID IN NUMBER
182 );
183
184 PROCEDURE ADD_LANGUAGE;
185
186
187 /********************************************************************
188 * API Type : Public APIs
189 * Purpose : Those APIs are public
190 *********************************************************************/
191
192
193 END Eng_Change_Route_People_Util ;