DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on CSP_REQ_LINE_DETAILS_PVT

Line 5097: l_req_line_dtl_rec CSP_REQ_LINE_DETAILS_PVT.Req_Line_Details_Tbl_Type;

5093: l_dest_org_id number;
5094: l_dest_subinv varchar2(40);
5095: l_need_by_date date;
5096: l_req_line_id number;
5097: l_req_line_dtl_rec CSP_REQ_LINE_DETAILS_PVT.Req_Line_Details_Tbl_Type;
5098: l_req_line_dtl_id number;
5099: l_req_hdr_pvt_rec CSP_Requirement_headers_PVT.REQUIREMENT_HEADER_Rec_Type;
5100: l_cancel_reason varchar2(200);
5101:

Line 5266: l_req_line_dtl_rec := CSP_REQ_LINE_DETAILS_PVT.G_MISS_Req_Line_Details_TBL;

5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5263: 'fetched l_oe_line_tbl...');
5264: end if;
5265:
5266: l_req_line_dtl_rec := CSP_REQ_LINE_DETAILS_PVT.G_MISS_Req_Line_Details_TBL;
5267: for i in 1..l_oe_line_tbl.count loop
5268:
5269: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5409: CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details(

5405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5406: 'l_req_line_dtl_rec.count = ' || l_req_line_dtl_rec.count);
5407: end if;
5408:
5409: CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details(
5410: P_Api_Version_Number => 1.0,
5411: P_Req_Line_Details_Tbl => l_req_line_dtl_rec,
5412: X_Return_Status => x_return_status,
5413: X_Msg_Count => x_msg_count,

Line 5419: 'after CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details... x_return_status = ' || x_return_status);

5415: );
5416:
5417: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5418: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5419: 'after CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details... x_return_status = ' || x_return_status);
5420: end if;
5421:
5422: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5423: rollback to csp_upd_oe_ship_to_add;