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:
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(
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,
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: );
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:
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(
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,
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: );
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:
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(
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,
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: );
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:
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(
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,
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: );
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:
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(
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,
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: );
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:
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(
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,
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: );
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:
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(
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,
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:
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: END ast_WebAssist_VUHK;
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: END ast_WebAssist_VUHK;