51: -- Parameters :
52: --
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57: --
58: -- Standard OUT Parameters :
59: -- x_return_status OUT VARCHAR2 Required
52: --
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57: --
58: -- Standard OUT Parameters :
59: -- x_return_status OUT VARCHAR2 Required
60: -- x_msg_count OUT NUMBER Required
84:
85: PROCEDURE Get_Route_Mtl_Req
86: (
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
85: PROCEDURE Get_Route_Mtl_Req
86: (
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_route_id IN NUMBER,
108: -- Parameters :
109: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
114: --
115: -- Standard OUT Parameters :
116: -- x_return_status OUT VARCHAR2 Required
109: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
114: --
115: -- Standard OUT Parameters :
116: -- x_return_status OUT VARCHAR2 Required
117: -- x_msg_count OUT NUMBER Required
138: --
139: -- End of Comments.
140: PROCEDURE Get_Material_Req_For_Pos (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
139: -- End of Comments.
140: PROCEDURE Get_Material_Req_For_Pos (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_uc_header_id IN NUMBER,
161: -- Parameters :
162: --
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
167: --
168: -- Standard OUT Parameters :
169: -- x_return_status OUT VARCHAR2 Required
162: --
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
167: --
168: -- Standard OUT Parameters :
169: -- x_return_status OUT VARCHAR2 Required
170: -- x_msg_count OUT NUMBER Required
179: -- Added by SURRKUMA on 20-DEC-2011
180: -- End of Comments
181: PROCEDURE Get_Alternate_Items(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_schedule_material_id IN NUMBER,
186: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
187: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,
180: -- End of Comments
181: PROCEDURE Get_Alternate_Items(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_schedule_material_id IN NUMBER,
186: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
187: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,
188: x_return_status OUT NOCOPY VARCHAR2,
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_schedule_material_id IN NUMBER,
186: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
187: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2);