[Home] [Help]
1465: crh.ship_to_location_id,
1466: decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id),
1467: decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
1468: from jtf_task_assignments jta,
1469: csp_requirement_headers crh
1470: where jta.task_assignment_id(+) = crh.task_assignment_id
1471: and crh.requirement_header_id = p_rqmt_header_id;
1472:
1473: /* bug # 8474563
1487: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1488: HZ_CUST_SITE_USES_ALL site_use,
1489: hz_party_site_uses hpsu,
1490: cs_incidents_all cia,
1491: csp_requirement_headers_v req
1492: WHERE req.requirement_header_id = p_rqmt_header_id
1493: and cia.incident_id = req.incident_id
1494: and cust_acct.cust_account_id = cia.bill_to_account_id
1495: and hpsu.party_site_use_id = cia.bill_to_site_use_id
1523: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1524: HZ_CUST_SITE_USES_ALL site_use,
1525: hz_party_site_uses hpsu,
1526: cs_incidents_all cia,
1527: csp_requirement_headers_v req
1528: WHERE req.requirement_header_id = v_rqmt_header_id
1529: and req.address_type in ('C', 'T') -- bug # 14743823
1530: and cia.incident_id = req.incident_id
1531: and cust_acct.cust_account_id = cia.bill_to_account_id
1864: l_sr_org_id := null;
1865: SELECT cia.org_id
1866: INTO l_sr_org_id
1867: FROM cs_incidents_all cia,
1868: csp_requirement_headers_v req
1869: WHERE req.requirement_header_id = l_header_rec.requirement_header_id
1870: AND cia.incident_id = req.incident_id;
1871:
1872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1884: -- bug # 13707506
1885: -- use ship to contact id while creating an internal order
1886: select nvl(ship_to_contact_id, -9999)
1887: into l_pr_ship_to_contact_id
1888: from csp_requirement_headers
1889: where requirement_header_id = l_header_rec.requirement_header_id;
1890:
1891: if l_pr_ship_to_contact_id <> -9999 then
1892: SELECT party_id
4910:
4911: cursor c_get_arrival_date is
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
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:
5102: cursor check_io_status is
5103: SELECT count(1)
5140: cursor get_req_header_data is
5141: SELECT destination_organization_id,
5142: destination_subinventory,
5143: need_by_date
5144: FROM csp_requirement_headers
5145: WHERE requirement_header_id = p_req_header_id;
5146:
5147: cursor get_req_line_id (v_oe_line_id number) is
5148: SELECT requirement_line_id,
5451: l_req_hdr_pvt_rec.ADDRESS_TYPE := p_new_add_type;
5452:
5453: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5455: 'before calling CSP_Requirement_headers_PVT.Update_requirement_headers...');
5456: end if;
5457:
5458: CSP_Requirement_headers_PVT.Update_requirement_headers(
5459: P_Api_Version_Number => 1.0,
5454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5455: 'before calling CSP_Requirement_headers_PVT.Update_requirement_headers...');
5456: end if;
5457:
5458: CSP_Requirement_headers_PVT.Update_requirement_headers(
5459: P_Api_Version_Number => 1.0,
5460: P_REQUIREMENT_HEADER_Rec => l_req_hdr_pvt_rec,
5461: X_Return_Status => x_return_status,
5462: X_Msg_Count => x_msg_count,
5464: );
5465:
5466: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5468: 'after calling CSP_Requirement_headers_PVT.Update_requirement_headers... x_return_status = ' || x_return_status);
5469: end if;
5470:
5471: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5472: rollback to csp_upd_oe_ship_to_add;