DBA Data[Home] [Help]

APPS.AST_WEBASSIST_VUHK 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: BEGIN

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: BEGIN
59: /* Vertical to add the customization PROCEDUREs here - for post processing */

Line 71: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 72: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 73: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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

Line 74: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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 */

Line 90: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 91: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 92: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 93: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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

Line 110: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 111: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 112: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 113: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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

Line 130: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 131: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 132: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 133: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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

Line 150: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 151: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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

Line 152: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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:

Line 153: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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