[Home] [Help]
991: -- check cancel flag at shipment level instead of at header level
992: -- because PO will cancel upto shipment level
993: AND (pll.cancel_flag IS NULL OR
994: pll.cancel_flag = 'N')
995: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND
996: -- nvl(PH.CANCEL_FLAG,'N') ='N')
997: -- OR
998: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
999: -- PR.PO_RELEASE_ID = PD.PO_RELEASE_ID AND
1039: -- because PO will cancel upto shipment level
1040: AND (pll.cancel_flag IS NULL OR
1041: pll.cancel_flag = 'N')
1042: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
1043: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND
1044: -- nvl(PH.CANCEL_FLAG, 'N') = 'N' )
1045: -- OR
1046: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
1047: -- nvl(PR.CANCEL_FLAG, 'N') = 'N'))
1441: po_headers_all ph,
1442: po_lines_all pl,
1443: po_line_locations_all pll,
1444: po_line_types plt
1445: WHERE ph.type_lookup_code = 'STANDARD'
1446: AND ph.po_header_id = pd.po_header_id
1447: AND pd.po_line_id = pl.po_line_id
1448: AND pd.line_location_id = pll.line_location_id
1449: AND pl.line_type_id = plt.line_type_id
1698: -- Set OU context before calling PO API. This change is mandatory for
1699: -- MOAC change in R12.
1700: mo_global.set_policy_context('S',p_ou_id);
1701: -- Update PO need by date and promise date
1702: IF(p_po_req_type IN('STANDARD', 'BLANKET')) THEN
1703: IF(p_approval_status IS NULL OR -- INCOMPLETE
1704: p_approval_status IN('INCOMPLETE',
1705: 'APPROVED',
1706: 'REQUIRES REAPPROVAL')) THEN
1957: wip_operation_resources wor,
1958: wip_operations wo,
1959: wip_discrete_jobs wdj,
1960: wip_repetitive_schedules wrs
1961: WHERE ph.type_lookup_code = 'STANDARD'
1962: AND ph.po_header_id = pd.po_header_id
1963: AND pd.line_location_id = pll.line_location_id
1964: AND pd.po_line_id = pl.po_line_id
1965: AND pd.wip_entity_id = wdj.wip_entity_id (+)
2236: FOR l_update_po_qty IN c_update_po_qty LOOP
2237: -- Set OU context before calling PO API. This change is
2238: -- mandatory for MOAC change in R12.
2239: mo_global.set_policy_context('S',l_update_po_qty.ou_id);
2240: IF (l_update_po_qty.po_req_type IN ('STANDARD', 'BLANKET')) THEN
2241: IF (l_update_po_qty.approval_status IS NULL OR -- INCOMPLETE
2242: l_update_po_qty.approval_status IN ('INCOMPLETE',
2243: 'APPROVED',
2244: 'REQUIRES REAPPROVAL')) THEN
2420: x_return_status OUT NOCOPY VARCHAR2,
2421: p_clr_fnd_mes_flag IN VARCHAR2 DEFAULT NULL) IS
2422: -- added parameter p_clr_fnd_mes_flag for bugfix 7229689.
2423: -- Bug fix 8681037: Changed the default value from 'N' to NULL for p_clr_fnd_mes_flag parameter
2424: -- as per the standards.
2425:
2426: CURSOR c_po_req IS
2427: SELECT pd.po_header_id po_header_id,
2428: to_number(null) po_release_id,
2440: po_line_locations_all pll
2441: /* Fixed bug 3115844 */
2442: WHERE pd.po_line_id IS NOT NULL
2443: AND pd.line_location_id IS NOT NULL
2444: AND ph.type_lookup_code = 'STANDARD'
2445: AND ph.po_header_id = pd.po_header_id
2446: AND pd.line_location_id = pll.line_location_id
2447: AND pd.wip_entity_id = p_job_id
2448: AND pd.destination_organization_id = p_org_id
2543: BEGIN
2544: -- Set OU context before calling PO API. This change is
2545: -- mandatory for MOAC change in R12.
2546: mo_global.set_policy_context('S',l_po_req.ou_id);
2547: IF (l_po_req.po_req_type IN ('STANDARD', 'BLANKET'))THEN
2548: -- Call PO API to cancel PO/release. If unable to cancel PO/release
2549: -- for any reason,skip the error one and try to cancel the next one.
2550:
2551: IF (l_logLevel <= wip_constants.full_logging) THEN