APPS.CSP_PARTS_ORDER dependencies on CSP_REQ_LINE_DETAILS

Line 4916: csp_req_line_details cld

4912: SELECT csp.arrival_date
4913: FROM CSP_SHIPPING_DETAILS_V csp,
4914: csp_requirement_headers ch,
4915: csp_requirement_lines cl,
4916: csp_req_line_details cld
4917: WHERE csp.organization_id = l_ship_from_org_id
4918: AND csp.shipping_method = p_ship_method
4919: AND cld.source_id = p_oe_line_id
4920: AND cld.requirement_line_id = cl.requirement_line_id

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 5105: csp_req_line_details cld,

5101:
5102: cursor check_io_status is
5103: SELECT count(1)
5104: FROM csp_requirement_lines cl,
5105: csp_req_line_details cld,
5106: oe_order_lines_all oel
5107: WHERE cl.requirement_header_id = p_req_header_id
5108: AND cl.requirement_line_id = cld.requirement_line_id
5109: AND cld.source_type = 'IO'

Line 5116: csp_req_line_details cld,

5112:
5113: cursor get_booked_order_num is
5114: SELECT oeh.order_number
5115: FROM csp_requirement_lines cl,
5116: csp_req_line_details cld,
5117: oe_order_lines_all oel,
5118: oe_order_headers_all oeh
5119: WHERE cl.requirement_header_id = p_req_header_id
5120: AND cl.requirement_line_id = cld.requirement_line_id

Line 5130: csp_req_line_details cld,

5126:
5127: cursor get_order_header_ids is
5128: SELECT distinct oel.header_id
5129: FROM csp_requirement_lines cl,
5130: csp_req_line_details cld,
5131: oe_order_lines_all oel
5132: WHERE cl.requirement_header_id = p_req_header_id
5133: AND cl.requirement_line_id = cld.requirement_line_id
5134: AND cld.source_type = 'IO'

Line 5150: FROM csp_req_line_details

5146:
5147: cursor get_req_line_id (v_oe_line_id number) is
5148: SELECT requirement_line_id,
5149: req_line_detail_id
5150: FROM csp_req_line_details
5151: WHERE source_type= 'IO'
5152: AND source_id = v_oe_line_id;
5153:
5154: BEGIN

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 5380: -- update the csp_req_line_details

5376: 'x_msg_data = ' || x_msg_data);
5377: end if;
5378:
5379: else
5380: -- update the csp_req_line_details
5381: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5383: 'populating l_req_line_dtl_rec...');
5384: end if;

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;