[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_ROUTE_ASSOCS_UTIL
Source
1 PACKAGE Eng_Change_Route_Assocs_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGURTAS.pls 115.0 2003/09/30 01:16:45 mkimizuk 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
32 /********************************************************************
33 * API Type : Private Copy Associations API
34 * Purpose : This api will copy instances for Route Associaitons
35 *********************************************************************/
36 PROCEDURE COPY_ASSOCIATIONS (
37 P_FROM_PEOPLE_ID IN NUMBER ,
38 P_TO_PEOPLE_ID IN NUMBER ,
39 P_USER_ID IN NUMBER := NULL ,
40 P_API_CALLER IN VARCHAR2 := NULL
41 ) ;
42
43
44
45 /********************************************************************
46 * API Type : Private Table Hander APIs
47 * Purpose : Those APIs are private
48 * Table Hander for Entity Object:
49 * ENG_CHANGE_ROUTE_ASSOCS
50 * PROCEDURE INSERT_ROW;
51 * -- Not Supproting PROCEDURE LOCK_ROW;
52 * -- Not Supproting PROCEDURE UPDATE_ROW;
53 * -- Not Supproting PROCEDURE DELETE_ROW;
54 *********************************************************************/
55 PROCEDURE INSERT_ROW (
56 X_ROWID IN OUT NOCOPY VARCHAR2,
57 X_ROUTE_ASSOCIATION_ID IN NUMBER,
58 X_ROUTE_PEOPLE_ID IN NUMBER,
59 X_ASSOC_OBJECT_NAME IN VARCHAR2,
60 X_ASSOC_OBJ_PK1_VALUE IN VARCHAR2,
61 X_ASSOC_OBJ_PK2_VALUE IN VARCHAR2,
62 X_ASSOC_OBJ_PK3_VALUE IN VARCHAR2,
63 X_ASSOC_OBJ_PK4_VALUE IN VARCHAR2,
64 X_ASSOC_OBJ_PK5_VALUE IN VARCHAR2,
65 X_OBJECT_NAME IN VARCHAR2,
66 X_OBJECT_ID1 IN NUMBER,
67 X_OBJECT_ID2 IN NUMBER,
68 X_OBJECT_ID3 IN NUMBER,
69 X_OBJECT_ID4 IN NUMBER,
70 X_OBJECT_ID5 IN NUMBER,
71 X_REQUEST_ID IN NUMBER,
72 X_CREATION_DATE IN DATE,
73 X_CREATED_BY IN NUMBER,
74 X_LAST_UPDATE_DATE IN DATE,
75 X_LAST_UPDATED_BY IN NUMBER,
76 X_LAST_UPDATE_LOGIN IN NUMBER,
77 X_PROGRAM_ID IN NUMBER,
78 X_PROGRAM_APPLICATION_ID IN NUMBER,
79 X_PROGRAM_UPDATE_DATE IN DATE,
80 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
81 X_ADHOC_ASSOC_FLAG IN VARCHAR2
82 );
83
84 /********************************************
85 PROCEDURE LOCK_ROW (
86 X_ROUTE_ASSOCIATION_ID IN NUMBER,
87 X_ROUTE_PEOPLE_ID IN NUMBER,
88 X_ASSOC_OBJECT_NAME IN VARCHAR2,
89 X_ASSOC_OBJ_PK1_VALUE IN VARCHAR2,
90 X_ASSOC_OBJ_PK2_VALUE IN VARCHAR2,
91 X_ASSOC_OBJ_PK3_VALUE IN VARCHAR2,
92 X_ASSOC_OBJ_PK4_VALUE IN VARCHAR2,
93 X_ASSOC_OBJ_PK5_VALUE IN VARCHAR2,
94 X_OBJECT_NAME IN VARCHAR2,
95 X_OBJECT_ID1 IN NUMBER,
96 X_OBJECT_ID2 IN NUMBER,
97 X_OBJECT_ID3 IN NUMBER,
98 X_OBJECT_ID4 IN NUMBER,
99 X_OBJECT_ID5 IN NUMBER,
100 X_REQUEST_ID IN NUMBER,
101 X_PROGRAM_ID IN NUMBER,
102 X_PROGRAM_APPLICATION_ID IN NUMBER,
103 X_PROGRAM_UPDATE_DATE IN DATE,
104 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
105 X_ADHOC_ASSOC_FLAG IN VARCHAR2,
106 );
107
108
109
110 PROCEDURE UPDATE_ROW (
111 X_ROUTE_ASSOCIATION_ID IN NUMBER,
112 X_ROUTE_PEOPLE_ID IN NUMBER,
113 X_ASSOC_OBJECT_NAME IN VARCHAR2,
114 X_ASSOC_OBJ_PK1_VALUE IN VARCHAR2,
115 X_ASSOC_OBJ_PK2_VALUE IN VARCHAR2,
116 X_ASSOC_OBJ_PK3_VALUE IN VARCHAR2,
117 X_ASSOC_OBJ_PK4_VALUE IN VARCHAR2,
118 X_ASSOC_OBJ_PK5_VALUE IN VARCHAR2,
119 X_OBJECT_NAME IN VARCHAR2,
120 X_OBJECT_ID1 IN NUMBER,
121 X_OBJECT_ID2 IN NUMBER,
122 X_OBJECT_ID3 IN NUMBER,
123 X_OBJECT_ID4 IN NUMBER,
124 X_OBJECT_ID5 IN NUMBER,
125 X_REQUEST_ID IN NUMBER,
126 X_LAST_UPDATE_DATE IN DATE,
127 X_LAST_UPDATED_BY IN NUMBER,
128 X_LAST_UPDATE_LOGIN IN NUMBER,
129 X_PROGRAM_ID IN NUMBER,
130 X_PROGRAM_APPLICATION_ID IN NUMBER,
131 X_PROGRAM_UPDATE_DATE IN DATE,
132 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
133 X_ADHOC_ASSOC_FLAG IN VARCHAR2,
134 ) ;
135
136
137
138 PROCEDURE DELETE_ROW (
139 X_ROUTE_ASSOCIATION_ID IN NUMBER
140 );
141 ********************************************/
142
143 -- PROCEDURE ADD_LANGUAGE;
144
145
146 /********************************************************************
147 * API Type : Public APIs
148 * Purpose : Those APIs are public
149 *********************************************************************/
150
151
152 END Eng_Change_Route_Assocs_Util ;