APPS.AST_WEBASSIST_CUHK dependencies on AST_WEBASSIST_PVT

Line 12: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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: )

Line 13: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 14: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 15: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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

Line 32: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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: )

Line 33: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 34: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 35: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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

Line 52: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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: )

Line 53: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 54: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 55: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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:
59: BEGIN

Line 72: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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,
73: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
74: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
75: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
76: )

Line 73: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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,
73: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
74: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
75: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
76: )
77: AS

Line 74: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

70: x_msg_count OUT NUMBER,
71: x_msg_data OUT VARCHAR2,
72: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
73: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
74: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
75: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
76: )
77: AS
78:

Line 75: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

71: x_msg_data OUT VARCHAR2,
72: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
73: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
74: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
75: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
76: )
77: AS
78:
79: BEGIN

Line 92: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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,
93: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
94: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
95: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
96: )

Line 93: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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,
93: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
94: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
95: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
96: )
97: AS

Line 94: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

90: x_msg_count OUT NUMBER,
91: x_msg_data OUT VARCHAR2,
92: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
93: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
94: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
95: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
96: )
97: AS
98:

Line 95: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

91: x_msg_data OUT VARCHAR2,
92: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
93: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
94: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
95: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
96: )
97: AS
98:
99: BEGIN

Line 113: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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,
114: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
115: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
116: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
117: )

Line 114: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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,
114: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
115: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
116: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
117: )
118: AS

Line 115: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

111: x_msg_count OUT NUMBER,
112: x_msg_data OUT VARCHAR2,
113: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
114: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
115: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
116: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
117: )
118: AS
119:

Line 116: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

112: x_msg_data OUT VARCHAR2,
113: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
114: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
115: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
116: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
117: )
118: AS
119:
120: BEGIN

Line 133: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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,
134: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
135: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
136: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
137: )

Line 134: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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,
134: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
135: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
136: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
137: )
138: AS

Line 135: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

131: x_msg_count OUT NUMBER,
132: x_msg_data OUT VARCHAR2,
133: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
134: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
135: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
136: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
137: )
138: AS
139:

Line 136: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

132: x_msg_data OUT VARCHAR2,
133: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
134: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
135: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
136: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
137: )
138: AS
139:
140: BEGIN

Line 153: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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,
154: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
155: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
156: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
157: )

Line 154: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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,
154: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
155: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
156: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
157: )
158: AS

Line 155: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

151: x_msg_count OUT NUMBER,
152: x_msg_data OUT VARCHAR2,
153: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
154: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
155: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
156: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
157: )
158: AS
159:

Line 156: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

152: x_msg_data OUT VARCHAR2,
153: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
154: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
155: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
156: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
157: )
158: AS
159:
160: BEGIN