DBA Data[Home] [Help]

APPS.AMS_LIST_QUERY_PUB dependencies on FND_API

Line 31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

27: -- Parameters
28: --
29: -- IN
30: -- p_api_version_number IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_list_query_rec IN list_query_rec_type Required
34: --
35: -- OUT

Line 32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

28: --
29: -- IN
30: -- p_api_version_number IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_list_query_rec IN list_query_rec_type Required
34: --
35: -- OUT
36: -- x_return_status OUT VARCHAR2

Line 49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

45: --
46:
47: PROCEDURE Create_List_Query(
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51:
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,

Line 50: p_commit IN VARCHAR2 := FND_API.G_FALSE,

46:
47: PROCEDURE Create_List_Query(
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51:
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,

Line 62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

58: );
59:
60: PROCEDURE Create_List_Query(
61: p_api_version_number IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,

Line 63: p_commit IN VARCHAR2 := FND_API.G_FALSE,

59:
60: PROCEDURE Create_List_Query(
61: p_api_version_number IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,

Line 64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

60: PROCEDURE Create_List_Query(
61: p_api_version_number IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,

Line 88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

84: -- Parameters
85: --
86: -- IN
87: -- p_api_version_number IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_list_query_rec IN list_query_rec_type Required
91: --
92: -- OUT

Line 89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

85: --
86: -- IN
87: -- p_api_version_number IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_list_query_rec IN list_query_rec_type Required
91: --
92: -- OUT
93: -- x_return_status OUT VARCHAR2

Line 107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

103:
104:
105: PROCEDURE Update_List_Query(
106: p_api_version_number IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,

Line 108: p_commit IN VARCHAR2 := FND_API.G_FALSE,

104:
105: PROCEDURE Update_List_Query(
106: p_api_version_number IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,

Line 120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

116: );
117:
118: PROCEDURE Update_List_Query(
119: p_api_version_number IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,

Line 121: p_commit IN VARCHAR2 := FND_API.G_FALSE,

117:
118: PROCEDURE Update_List_Query(
119: p_api_version_number IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,

Line 122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

118: PROCEDURE Update_List_Query(
119: p_api_version_number IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,

Line 146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

142: -- Parameters
143: --
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_LIST_QUERY_ID IN NUMBER
149: -- p_object_version_number IN NUMBER Optional Default = NULL
150: --

Line 147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

143: --
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_LIST_QUERY_ID IN NUMBER
149: -- p_object_version_number IN NUMBER Optional Default = NULL
150: --
151: -- OUT

Line 165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

161: --
162:
163: PROCEDURE Delete_List_Query(
164: p_api_version_number IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,

Line 166: p_commit IN VARCHAR2 := FND_API.G_FALSE,

162:
163: PROCEDURE Delete_List_Query(
164: p_api_version_number IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_list_query_id IN NUMBER,

Line 176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

172: );
173:
174: PROCEDURE Delete_parent_List_Query(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,

Line 177: p_commit IN VARCHAR2 := FND_API.G_FALSE,

173:
174: PROCEDURE Delete_parent_List_Query(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,

Line 178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

174: PROCEDURE Delete_parent_List_Query(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_parent_list_query_id IN NUMBER,

Line 200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_list_query_rec IN list_query_rec_type Required
203: --
204: -- OUT

Line 201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_list_query_rec IN list_query_rec_type Required
203: --
204: -- OUT
205: -- x_return_status OUT VARCHAR2

Line 218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

214: --
215:
216: PROCEDURE Lock_List_Query(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: