DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PVT dependencies on FND_API

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

69: -- End of Comments.
70:
71: PROCEDURE Create_Position_ID (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,

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

70:
71: PROCEDURE Create_Position_ID (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,

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

71: PROCEDURE Create_Position_ID (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

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

96: -- End of Comments.
97:
98: PROCEDURE Map_Instance_To_Positions (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

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

97:
98: PROCEDURE Map_Instance_To_Positions (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,

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

98: PROCEDURE Map_Instance_To_Positions (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_csi_item_instance_id IN NUMBER);

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

120: -- End of Comments.
121:
122: PROCEDURE Map_Position_To_Instances (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,

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

121:
122: PROCEDURE Map_Position_To_Instances (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,

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

122: PROCEDURE Map_Position_To_Instances (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_position_id IN NUMBER);

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

146: -- End of Comments.
147:
148: PROCEDURE Map_Instance_To_Pos_ID (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,

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

147:
148: PROCEDURE Map_Instance_To_Pos_ID (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,

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

148: PROCEDURE Map_Instance_To_Pos_ID (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_csi_item_instance_id IN NUMBER,

Line 157: p_relationship_id IN NUMBER := FND_API.G_MISS_NUM,

153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_csi_item_instance_id IN NUMBER,
157: p_relationship_id IN NUMBER := FND_API.G_MISS_NUM,
158: x_path_position_id OUT NOCOPY NUMBER);
159:
160: ----------------------------
161: -- Start of Comments --

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

177: -- EMPTY (Empty position) or MATCH (if matching instance found)
178: -- End of Comments.
179: PROCEDURE Get_Pos_Instance (
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,

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

178: -- End of Comments.
179: PROCEDURE Get_Pos_Instance (
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,

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

179: PROCEDURE Get_Pos_Instance (
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_position_id IN NUMBER,

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

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

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

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

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

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

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

240: -- End of Comments.
241:
242: PROCEDURE Copy_Positions_For_MC (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,

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

241:
242: PROCEDURE Copy_Positions_For_MC (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,

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

242: PROCEDURE Copy_Positions_For_MC (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_from_mc_header_id IN NUMBER,

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

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

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

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

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

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

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

292: -- End of Comments.
293:
294: PROCEDURE Delete_Positions_For_MC (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_commit IN VARCHAR2 := FND_API.G_FALSE,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,

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

293:
294: PROCEDURE Delete_Positions_For_MC (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_commit IN VARCHAR2 := FND_API.G_FALSE,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,

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

294: PROCEDURE Delete_Positions_For_MC (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_commit IN VARCHAR2 := FND_API.G_FALSE,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_mc_header_id IN NUMBER);

Line 315: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return

311: -- Parameters :
312: --
313: -- get_position_ref_code Parameters:
314: -- p_position_id IN NUMBER the path position id
315: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
316: -- pos ref code, else return pos ref meaning. Default to False.
317: --
318: FUNCTION get_posref_by_id(
319: p_path_position_ID IN NUMBER,

Line 320: p_code_flag IN VARCHAR2 := FND_API.G_FALSE)

316: -- pos ref code, else return pos ref meaning. Default to False.
317: --
318: FUNCTION get_posref_by_id(
319: p_path_position_ID IN NUMBER,
320: p_code_flag IN VARCHAR2 := FND_API.G_FALSE)
321: RETURN VARCHAR2; -- Position Ref Code
322:
323: ---------------------------------------------------------------------
324: -- Start of Comments --

Line 333: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return

329: -- Parameters :
330: --
331: -- get_position_ref_code Parameters:
332: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
333: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
334: -- pos ref code, else return pos ref meaning. Default to False.
335: --
336: FUNCTION get_posref_by_path(
337: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

Line 338: p_code_flag IN VARCHAR2 := FND_API.G_FALSE

334: -- pos ref code, else return pos ref meaning. Default to False.
335: --
336: FUNCTION get_posref_by_path(
337: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
338: p_code_flag IN VARCHAR2 := FND_API.G_FALSE
339: )
340: RETURN VARCHAR2; -- Position Ref Code
341:
342: ---------------------------------------------------------------------