DBA Data[Home] [Help]

APPS.CN_TABLE_MAPS_PVT dependencies on FND_API

Line 36: -- Default = FND_API.G_FALSE

32: -- and all of the objects that are associated with it.
33: -- Parameters :
34: -- IN : p_api_version NUMBER Required
35: -- p_init_msg_list VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_commit VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 38: -- Default = FND_API.G_FALSE

34: -- IN : p_api_version NUMBER Required
35: -- p_init_msg_list VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_commit VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL
41: -- OUT : x_return_status VARCHAR2(1)
42: -- x_msg_count NUMBER

Line 40: -- Default = FND_API.G_VALID_LEVEL_FULL

36: -- Default = FND_API.G_FALSE
37: -- p_commit VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL
41: -- OUT : x_return_status VARCHAR2(1)
42: -- x_msg_count NUMBER
43: -- x_msg_data VARCHAR2(2000)
44: -- IN : p_source_name VARCHAR2 Required

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

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

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

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

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

61: PROCEDURE Create_Map (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_source_name IN VARCHAR2 ,

Line 82: -- Default = FND_API.G_FALSE

78: -- and all of the objects that are associated with it.
79: -- Parameters :
80: -- IN : p_api_version NUMBER Required
81: -- p_init_msg_list VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 84: -- Default = FND_API.G_FALSE

80: -- IN : p_api_version NUMBER Required
81: -- p_init_msg_list VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- OUT : x_return_status VARCHAR2(1)
88: -- x_msg_count NUMBER

Line 86: -- Default = FND_API.G_VALID_LEVEL_FULL

82: -- Default = FND_API.G_FALSE
83: -- p_commit VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- OUT : x_return_status VARCHAR2(1)
88: -- x_msg_count NUMBER
89: -- x_msg_data VARCHAR2(2000)
90: -- IN : p_table_map_id NUMBER Required

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

92: --
93: -- End of comments
94: PROCEDURE Delete_Map (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,

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

93: -- End of comments
94: PROCEDURE Delete_Map (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,

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

94: PROCEDURE Delete_Map (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_table_map_id IN NUMBER,

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

104:
105: PROCEDURE Update_Map
106: (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,

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

105: PROCEDURE Update_Map
106: (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,

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

106: (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_table_map_id IN NUMBER,

Line 149: -- Default = FND_API.G_FALSE

145: -- cn_table_map_objects_pkg.insert_row procedure.
146: -- Parameters :
147: -- IN : p_api_version NUMBER Required
148: -- p_init_msg_list VARCHAR2 Optional
149: -- Default = FND_API.G_FALSE
150: -- p_commit VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- p_validation_level NUMBER Optional
153: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 151: -- Default = FND_API.G_FALSE

147: -- IN : p_api_version NUMBER Required
148: -- p_init_msg_list VARCHAR2 Optional
149: -- Default = FND_API.G_FALSE
150: -- p_commit VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- p_validation_level NUMBER Optional
153: -- Default = FND_API.G_VALID_LEVEL_FULL
154: -- OUT : x_return_status VARCHAR2(1)
155: -- x_msg_count NUMBER

Line 153: -- Default = FND_API.G_VALID_LEVEL_FULL

149: -- Default = FND_API.G_FALSE
150: -- p_commit VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- p_validation_level NUMBER Optional
153: -- Default = FND_API.G_VALID_LEVEL_FULL
154: -- OUT : x_return_status VARCHAR2(1)
155: -- x_msg_count NUMBER
156: -- x_msg_data VARCHAR2(2000)
157: -- IN : p_table_map_id NUMBER Required

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

168: --
169: -- End of comments
170: PROCEDURE Create_Table_Map_Object (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,

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

169: -- End of comments
170: PROCEDURE Create_Table_Map_Object (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,

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

170: PROCEDURE Create_Table_Map_Object (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_table_map_id IN NUMBER,

Line 203: -- Default = FND_API.G_FALSE

199: -- then just use the cn_table_map_objects_pkg.delete_row procedure.
200: -- Parameters :
201: -- IN : p_api_version NUMBER Required
202: -- p_init_msg_list VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_commit VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 205: -- Default = FND_API.G_FALSE

201: -- IN : p_api_version NUMBER Required
202: -- p_init_msg_list VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_commit VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL
208: -- OUT : x_return_status VARCHAR2(1)
209: -- x_msg_count NUMBER

Line 207: -- Default = FND_API.G_VALID_LEVEL_FULL

203: -- Default = FND_API.G_FALSE
204: -- p_commit VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL
208: -- OUT : x_return_status VARCHAR2(1)
209: -- x_msg_count NUMBER
210: -- x_msg_data VARCHAR2(2000)
211: -- IN : p_table_map_object_id NUMBER Required

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

212: --
213: -- End of comments
214: PROCEDURE Delete_Table_Map_Object (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,

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

213: -- End of comments
214: PROCEDURE Delete_Table_Map_Object (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,

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

214: PROCEDURE Delete_Table_Map_Object (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_table_map_object_id IN NUMBER,

Line 236: -- Default = FND_API.G_FALSE

232: -- stored for that source in CN_TABLE_MAPS
233: -- Parameters :
234: -- IN : p_api_version IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional
236: -- Default = FND_API.G_FALSE
237: -- p_commit IN VARCHAR2 Optional
238: -- Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional
240: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 238: -- Default = FND_API.G_FALSE

234: -- IN : p_api_version IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional
236: -- Default = FND_API.G_FALSE
237: -- p_commit IN VARCHAR2 Optional
238: -- Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional
240: -- Default = FND_API.G_VALID_LEVEL_FULL
241: -- OUT : x_return_status OUT VARCHAR2(1)
242: -- x_msg_count OUT NUMBER

Line 240: -- Default = FND_API.G_VALID_LEVEL_FULL

236: -- Default = FND_API.G_FALSE
237: -- p_commit IN VARCHAR2 Optional
238: -- Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional
240: -- Default = FND_API.G_VALID_LEVEL_FULL
241: -- OUT : x_return_status OUT VARCHAR2(1)
242: -- x_msg_count OUT NUMBER
243: -- x_msg_data OUT VARCHAR2(2000)
244: -- IN : p_table_map_id IN NUMBER Required

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

249: --
250: -- End of comments
251: PROCEDURE Get_SQL_Clauses
252: ( p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,

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

250: -- End of comments
251: PROCEDURE Get_SQL_Clauses
252: ( p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,

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

251: PROCEDURE Get_SQL_Clauses
252: ( p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_table_map_id IN NUMBER,

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

266:
267: PROCEDURE Update_Table_Map_Objects
268: (
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,

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

267: PROCEDURE Update_Table_Map_Objects
268: (
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,

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

268: (
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_table_map_id IN NUMBER,