2: /* $Header: astvwaub.pls 115.3 2002/02/06 11:21:18 pkm ship $ */
3:
4: PROCEDURE Create_WebAssist_PRE (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
3:
4: PROCEDURE Create_WebAssist_PRE (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
4: PROCEDURE Create_WebAssist_PRE (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
12: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
22: END;
23:
24: PROCEDURE Create_WebAssist_POST(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT VARCHAR2,
30: x_msg_count OUT NUMBER,
23:
24: PROCEDURE Create_WebAssist_POST(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT VARCHAR2,
30: x_msg_count OUT NUMBER,
31: x_msg_data OUT VARCHAR2,
24: PROCEDURE Create_WebAssist_POST(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT VARCHAR2,
30: x_msg_count OUT NUMBER,
31: x_msg_data OUT VARCHAR2,
32: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
42: END;
43:
44: PROCEDURE Lock_WebAssist_PRE(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT VARCHAR2,
50: x_msg_count OUT NUMBER,
43:
44: PROCEDURE Lock_WebAssist_PRE(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT VARCHAR2,
50: x_msg_count OUT NUMBER,
51: x_msg_data OUT VARCHAR2,
44: PROCEDURE Lock_WebAssist_PRE(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT VARCHAR2,
50: x_msg_count OUT NUMBER,
51: x_msg_data OUT VARCHAR2,
52: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
62: END;
63:
64: PROCEDURE Lock_WebAssist_POST(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT VARCHAR2,
70: x_msg_count OUT NUMBER,
63:
64: PROCEDURE Lock_WebAssist_POST(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT VARCHAR2,
70: x_msg_count OUT NUMBER,
71: x_msg_data OUT VARCHAR2,
64: PROCEDURE Lock_WebAssist_POST(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT VARCHAR2,
70: x_msg_count OUT NUMBER,
71: x_msg_data OUT VARCHAR2,
72: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
82: END;
83:
84: PROCEDURE Update_WebAssist_PRE(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
83:
84: PROCEDURE Update_WebAssist_PRE(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
84: PROCEDURE Update_WebAssist_PRE(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT VARCHAR2,
90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
92: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
103:
104:
105: PROCEDURE Update_WebAssist_POST(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT VARCHAR2,
111: x_msg_count OUT NUMBER,
104:
105: PROCEDURE Update_WebAssist_POST(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT VARCHAR2,
111: x_msg_count OUT NUMBER,
112: x_msg_data OUT VARCHAR2,
105: PROCEDURE Update_WebAssist_POST(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT VARCHAR2,
111: x_msg_count OUT NUMBER,
112: x_msg_data OUT VARCHAR2,
113: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
123: END;
124:
125: PROCEDURE Delete_WebAssist_PRE(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: x_return_status OUT VARCHAR2,
131: x_msg_count OUT NUMBER,
124:
125: PROCEDURE Delete_WebAssist_PRE(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: x_return_status OUT VARCHAR2,
131: x_msg_count OUT NUMBER,
132: x_msg_data OUT VARCHAR2,
125: PROCEDURE Delete_WebAssist_PRE(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: x_return_status OUT VARCHAR2,
131: x_msg_count OUT NUMBER,
132: x_msg_data OUT VARCHAR2,
133: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
143: END;
144:
145: PROCEDURE Delete_WebAssist_POST(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT VARCHAR2,
151: x_msg_count OUT NUMBER,
144:
145: PROCEDURE Delete_WebAssist_POST(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT VARCHAR2,
151: x_msg_count OUT NUMBER,
152: x_msg_data OUT VARCHAR2,
145: PROCEDURE Delete_WebAssist_POST(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT VARCHAR2,
151: x_msg_count OUT NUMBER,
152: x_msg_data OUT VARCHAR2,
153: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
163: END;
164:
165: FUNCTION Ok_To_Launch_Workflow(
166: p_api_version IN NUMBER := 1.0,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER :=
170: FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
164:
165: FUNCTION Ok_To_Launch_Workflow(
166: p_api_version IN NUMBER := 1.0,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER :=
170: FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
166: p_api_version IN NUMBER := 1.0,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER :=
170: FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
173: x_msg_data OUT VARCHAR2) RETURN BOOLEAN is
174: BEGIN
179:
180:
181: FUNCTION Ok_To_Generate_Msg(
182: p_api_version IN NUMBER := 1.0,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER :=
186: FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT VARCHAR2,
180:
181: FUNCTION Ok_To_Generate_Msg(
182: p_api_version IN NUMBER := 1.0,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER :=
186: FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT VARCHAR2,
188: x_msg_count OUT NUMBER,
182: p_api_version IN NUMBER := 1.0,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER :=
186: FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT VARCHAR2,
188: x_msg_count OUT NUMBER,
189: x_msg_data OUT VARCHAR2) RETURN BOOLEAN is
190: BEGIN