DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on FND_API

Line 191: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

187: l_order number := null;
188: l_nb_int_ext varchar2(30);
189: l_rep_int_ext varchar2(30);
190: l_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type;
191: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
192: l_msg_data VARCHAR2(2000);
193: l_msg_count NUMBER;
194: l_parent_type varchar2(30) := null;
195:

Line 425: , p_Init_Msg_List => FND_API.G_FALSE

421: l_line_tbl(1).plan_Date := cr.plan_date;
422:
423: CSP_PLANNED_ORDERS.create_orders(
424: p_api_version => 1.0
425: , p_Init_Msg_List => FND_API.G_FALSE
426: , p_commit => FND_API.G_FALSE
427: , p_organization_id => l_organization_id
428: , p_inventory_item_id => cr.supplied_item_id
429: , px_line_tbl => l_line_tbl

Line 426: , p_commit => FND_API.G_FALSE

422:
423: CSP_PLANNED_ORDERS.create_orders(
424: p_api_version => 1.0
425: , p_Init_Msg_List => FND_API.G_FALSE
426: , p_commit => FND_API.G_FALSE
427: , p_organization_id => l_organization_id
428: , p_inventory_item_id => cr.supplied_item_id
429: , px_line_tbl => l_line_tbl
430: , x_return_status => l_Return_status

Line 435: if l_return_status = FND_API.G_RET_STS_SUCCESS then

431: , x_msg_count => l_msg_count
432: , x_msg_data => l_msg_data);
433:
434:
435: if l_return_status = FND_API.G_RET_STS_SUCCESS then
436: update csp_plan_details
437: set plan_detail_type = decode(cr.plan_detail_type,'4110','8630',
438: '4210','8620',
439: '4310','8610'),