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: )
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: AS
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: AS
18:
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: AS
18:
19: BEGIN
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,
33: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
34: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
35: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
36: )
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,
33: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
34: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
35: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
36: )
37: AS
30: x_msg_count OUT NUMBER,
31: x_msg_data OUT VARCHAR2,
32: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
33: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
34: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
35: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
36: )
37: AS
38:
31: x_msg_data OUT VARCHAR2,
32: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
33: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
34: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
35: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
36: )
37: AS
38:
39: BEGIN
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,
53: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
54: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
55: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
56: )
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,
53: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
54: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
55: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
56: )
57: AS
50: x_msg_count OUT NUMBER,
51: x_msg_data OUT VARCHAR2,
52: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
53: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
54: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
55: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
56: )
57: AS
58: BEGIN
51: x_msg_data OUT VARCHAR2,
52: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
53: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
54: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
55: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
56: )
57: AS
58: BEGIN
59: /* Vertical to add the customization PROCEDUREs here - for post processing */
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: x_return_status OUT VARCHAR2,
69: x_msg_count OUT NUMBER,
70: x_msg_data OUT VARCHAR2,
71: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
72: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
73: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
74: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
75: )
68: x_return_status OUT VARCHAR2,
69: x_msg_count OUT NUMBER,
70: x_msg_data OUT VARCHAR2,
71: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
72: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
73: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
74: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
75: )
76: AS
69: x_msg_count OUT NUMBER,
70: x_msg_data OUT VARCHAR2,
71: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
72: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
73: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
74: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
75: )
76: AS
77: BEGIN
70: x_msg_data OUT VARCHAR2,
71: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
72: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
73: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
74: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
75: )
76: AS
77: BEGIN
78: /* Vertical to add the customization PROCEDUREs here - for post processing */
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT VARCHAR2,
88: x_msg_count OUT NUMBER,
89: x_msg_data OUT VARCHAR2,
90: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
91: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
92: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
93: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
94: )
87: x_return_status OUT VARCHAR2,
88: x_msg_count OUT NUMBER,
89: x_msg_data OUT VARCHAR2,
90: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
91: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
92: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
93: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
94: )
95: AS
88: x_msg_count OUT NUMBER,
89: x_msg_data OUT VARCHAR2,
90: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
91: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
92: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
93: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
94: )
95: AS
96:
89: x_msg_data OUT VARCHAR2,
90: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
91: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
92: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
93: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
94: )
95: AS
96:
97: BEGIN
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: )
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: AS
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: AS
116:
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: AS
116:
117: BEGIN
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT VARCHAR2,
128: x_msg_count OUT NUMBER,
129: x_msg_data OUT VARCHAR2,
130: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
131: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
132: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
133: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
134: )
127: x_return_status OUT VARCHAR2,
128: x_msg_count OUT NUMBER,
129: x_msg_data OUT VARCHAR2,
130: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
131: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
132: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
133: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
134: )
135: AS
128: x_msg_count OUT NUMBER,
129: x_msg_data OUT VARCHAR2,
130: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
131: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
132: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
133: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
134: )
135: AS
136:
129: x_msg_data OUT VARCHAR2,
130: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
131: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
132: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
133: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
134: )
135: AS
136:
137: BEGIN
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: x_return_status OUT VARCHAR2,
148: x_msg_count OUT NUMBER,
149: x_msg_data OUT VARCHAR2,
150: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
151: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
152: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
153: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
154: )
147: x_return_status OUT VARCHAR2,
148: x_msg_count OUT NUMBER,
149: x_msg_data OUT VARCHAR2,
150: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
151: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
152: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
153: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
154: )
155: AS
148: x_msg_count OUT NUMBER,
149: x_msg_data OUT VARCHAR2,
150: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
151: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
152: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
153: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
154: )
155: AS
156:
149: x_msg_data OUT VARCHAR2,
150: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
151: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
152: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
153: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
154: )
155: AS
156:
157: BEGIN