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:

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:
18: PROCEDURE Create_WebAssist_POST(

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:
18: PROCEDURE Create_WebAssist_POST(
19: p_api_version IN NUMBER,

Line 26: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 27: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 28: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 29: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

Line 40: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 41: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 42: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 43: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

Line 54: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 55: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 56: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 57: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

Line 68: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 69: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 70: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 71: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

Line 82: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 83: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 84: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 85: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

Line 96: p_assist_rec IN ast_WebAssist_PVT.assist_rec_type,

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

Line 97: p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,

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:

Line 98: p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,

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(

Line 99: p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type

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,

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:

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:
116: END ast_WebAssist_VUHK;

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:
116: END ast_WebAssist_VUHK;