DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on STANDARD

Line 481: -- Standard call to check for call compatibility.

477: -- initialize message list
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481: -- Standard call to check for call compatibility.
482:
483: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
484: p_api_version,
485: l_api_name,

Line 1493: if (v_type_code in ('STANDARD','PLANNED')) then

1489: select type_lookup_code , org_id
1490: into v_type_code , x_org_id
1491: from po_headers_all
1492: where po_header_id= p_po_header_id;
1493: if (v_type_code in ('STANDARD','PLANNED')) then
1494: v_document_type := 'PO';
1495: v_document_subtype := v_type_code;
1496: elsif (v_type_code in ('BLANKET','CONTRACT')) then
1497: v_document_type := 'PA';

Line 1539: -- if release / standard po referencing a GA/ Quotation

1535: shipmentNumTbl.extend;
1536: shipamountTbl.extend;
1537: progress_type_tbl.extend;
1538: pay_description_tbl.extend;
1539: -- if release / standard po referencing a GA/ Quotation
1540: -- Call Get Price Break API.
1541:
1542: --if ((p_po_change_requests(i).from_header_id is not null) or
1543: -- (p_po_change_requests(i).po_release_id is not null)) then

Line 1664: -- For Global Agreement refered Standard PO's x_cum_flag is always FALSE

1660: latest_external_flag='Y' ) and
1661: latest_external_flag='Y' and
1662: po_line_id = l_ga_lineId ;
1663:
1664: -- For Global Agreement refered Standard PO's x_cum_flag is always FALSE
1665: x_price := po_sourcing2_sv.get_break_price(
1666: l_total_qty, l_shipToOrg, l_shipToLoc, l_ga_lineId, x_cum_flag, l_needBydate, null);
1667:
1668: -- Post a line level change with the price returned from price break api

Line 1917: if (l_doc_type = 'STANDARD') then

1913: from po_headers_all poh, po_lines_all pol
1914: where poh.po_header_id = pol.po_header_id
1915: and po_line_id = p_po_line_id;
1916:
1917: if (l_doc_type = 'STANDARD') then
1918:
1919: -- Check if the line type is amount based then do not allow change
1920: --PO API does not cover this.
1921: begin

Line 1961: else --end of if l_doc_type = 'STANDARD'

1957: end if;
1958:
1959: end if;
1960:
1961: else --end of if l_doc_type = 'STANDARD'
1962: x_display_stat := 'Y'; --For blankets, planned, GAs, price is always changeable.
1963: end if;
1964:
1965:

Line 2036: if (v_type_code in ('STANDARD','PLANNED')) then

2032: p_document_id := p_po_header_id;
2033: select type_lookup_code into v_type_code
2034: from po_headers_all
2035: where po_header_id= p_po_header_id;
2036: if (v_type_code in ('STANDARD','PLANNED')) then
2037: v_document_type := 'PO';
2038: v_document_subtype := v_type_code;
2039: elsif (v_type_code in ('BLANKET','CONTRACT')) then
2040: v_document_type := 'PA';

Line 2094: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2091: WHERE
2092: POH.PO_HEADER_ID = p_po_header_id
2093: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2094: AND POH.TYPE_LOOKUP_CODE ='STANDARD'
2095: AND POLL.po_line_id = POL.po_line_id
2096: AND nvl(POLL.cancel_flag, 'N') = 'N'
2097: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2098: AND (nvl(POLL.quantity_received,0) >= nvl(POLL.quantity,0)

Line 2344: -- Standard call to check for call compatibility.

2340: -- initialize message list
2341: FND_MSG_PUB.initialize;
2342: END IF;
2343:
2344: -- Standard call to check for call compatibility.
2345:
2346: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2347: p_api_version,
2348: l_api_name,

Line 2512: -- Start standard API initialization

2508: initiator = 'SUPPLIER' and
2509: request_status not in ('ACCEPTED', 'REJECTED');
2510:
2511: BEGIN
2512: -- Start standard API initialization
2513: IF FND_API.to_boolean(p_init_msg_list) THEN
2514: FND_MSG_PUB.initialize;
2515: END IF;
2516: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

Line 2522: -- End standard API initialization

2518: THEN
2519: RAISE FND_API.g_exc_unexpected_error;
2520: END IF;
2521: x_return_status := FND_API.g_ret_sts_success;
2522: -- End standard API initialization
2523:
2524: -- Get the change request group id for the change requests if any
2525: if (p_po_release_id is not null) then
2526: open c2(p_po_release_id);

Line 2777: -- Standard call to check for call compatibility.

2773: -- initialize message list
2774: FND_MSG_PUB.initialize;
2775: END IF;
2776:
2777: -- Standard call to check for call compatibility.
2778:
2779: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2780: p_api_version,
2781: l_api_name,

Line 2789: if (p_document_subtype in ('STANDARD','PLANNED')) then

2785: END IF;
2786:
2787: -- initialize return status
2788: x_return_status := FND_API.G_RET_STS_SUCCESS;
2789: if (p_document_subtype in ('STANDARD','PLANNED')) then
2790: l_document_type := 'PO';
2791:
2792: elsif (p_document_subtype in ('BLANKET','CONTRACT')) then
2793: l_document_type := 'PA';