1 PACKAGE ast_WebAssist_CUHK AUTHID CURRENT_USER AS
2 /* $Header: astvwaus.pls 115.4 2002/02/06 11:21:20 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,
11 x_msg_data OUT VARCHAR2,
12 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
13 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
14 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
15 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
16 );
17
18 PROCEDURE Create_WebAssist_POST(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
21 p_commit IN VARCHAR2 := FND_API.G_FALSE,
22 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23 x_return_status OUT VARCHAR2,
24 x_msg_count OUT NUMBER,
25 x_msg_data OUT VARCHAR2,
26 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
27 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
28 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
29 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
30 );
31
32 PROCEDURE Lock_WebAssist_PRE(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 x_return_status OUT VARCHAR2,
38 x_msg_count OUT NUMBER,
39 x_msg_data OUT VARCHAR2,
40 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
41 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
42 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
43 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
44 );
45
46 PROCEDURE Lock_WebAssist_POST(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 x_return_status OUT VARCHAR2,
52 x_msg_count OUT NUMBER,
53 x_msg_data OUT VARCHAR2,
54 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
55 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
56 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
57 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
58 );
59
60 PROCEDURE Update_WebAssist_PRE(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 x_return_status OUT VARCHAR2,
66 x_msg_count OUT NUMBER,
67 x_msg_data OUT VARCHAR2,
68 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
69 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
70 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
71 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
72 );
73
74 PROCEDURE Update_WebAssist_POST(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77 p_commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79 x_return_status OUT VARCHAR2,
80 x_msg_count OUT NUMBER,
81 x_msg_data OUT VARCHAR2,
82 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
83 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
84 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
85 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
86 );
87
88 PROCEDURE Delete_WebAssist_PRE(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 x_return_status OUT VARCHAR2,
94 x_msg_count OUT NUMBER,
95 x_msg_data OUT VARCHAR2,
96 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
97 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
98 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
99 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
100 );
101
102 PROCEDURE Delete_WebAssist_POST(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 x_return_status OUT VARCHAR2,
108 x_msg_count OUT NUMBER,
109 x_msg_data OUT VARCHAR2,
110 p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
111 p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
112 p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
113 p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
114 );
115
116
117 FUNCTION Ok_To_Launch_Workflow(
118 p_api_version IN NUMBER := 1.0,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER :=
122 FND_API.G_VALID_LEVEL_FULL,
123 x_return_status OUT VARCHAR2,
124 x_msg_count OUT NUMBER,
125 x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
126
127
128 FUNCTION Ok_To_Generate_Msg(
129 p_api_version IN NUMBER := 1.0,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN NUMBER :=
133 FND_API.G_VALID_LEVEL_FULL,
134 x_return_status OUT VARCHAR2,
135 x_msg_count OUT NUMBER,
136 x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
137
138 END ast_WebAssist_CUHK;