eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DELREC_PVT dependencies on STANDARD

Line 134: -- Call FTE's API to create delivery record for Standard Purchase Order

130: -- l_fte_rec
131: --Locks:
132: -- None.
133: --Function:
134: -- Call FTE's API to create delivery record for Standard Purchase Order
135: -- and Blanket Release
136: --Parameters:
137: --IN:
138: --p_api_version

Line 145: -- Specifies Standard PO or Blanket Release.

141: -- Specifies doc control action.
142: --p_doc_type
143: -- Differentiates between the doc being a PO or Release.
144: --p_doc_subtype
145: -- Specifies Standard PO or Blanket Release.
146: --p_doc_id
147: -- Corresponding to po_header_id or po_release_id.
148: --p_line_id
149: -- Corresponding to po_line_id

Line 189: -- Standard Start of API savepoint

185: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;
186: l_fte_out_rec WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type;
187:
188: BEGIN
189: -- Standard Start of API savepoint
190: SAVEPOINT create_update_delrec;
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

196: x_progress:='000';
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check API Call Compatibility');
199: END IF;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call
202: (
203: p_current_version_number => l_api_version,
204: p_caller_version_number => p_api_version,

Line 287: -- Standard PO, Standard PO referencing GA or Contract

283: END IF;
284:
285:
286: -- The following is for query data to create delivery record for:
287: -- Standard PO, Standard PO referencing GA or Contract
288: x_progress:='015';
289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check doc type is ' || p_doc_type || ' doc subtype is ' || p_doc_subtype || '
291: doc id is ' || p_doc_id || ' line id is ' || p_line_id || ' line location id is ' || p_line_location_id );

Line 297: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN

293:
294: /* Bug 7232644: Checking of the value of the shipping control before calling the
295: procedure make_rcv_call.*/
296:
297: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN
298: SELECT shipping_control
299: INTO l_shipping_control
300: FROM PO_HEADERS_ALL
301: WHERE po_header_id = p_doc_id;

Line 343: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN

339: END IF;
340:
341:
342:
343: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN
344: l_action_rec.Entity := 'PO';
345: IF (l_action_rec.action_code = 'APPROVE_PO') THEN
346: get_approved_po
347: (

Line 533: END IF; -- IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' )

529: END IF;
530: END IF; -- l_fte_rec
531: -- Bug 3602512 END
532:
533: END IF; -- IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' )
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: FOR i IN 1..x_msg_count LOOP
537: x_msg_data := SUBSTR(x_msg_data || FND_MSG_PUB.Get(p_msg_index=>i, p_encoded =>'F' ), 1, 2000);

Line 694: 'STANDARD', 1,

690: msi.volume_uom_code,
691: rsh.ship_to_org_id,
692: poh.segment1,
693: DECODE (poh.type_lookup_code,
694: 'STANDARD', 1,
695: 'BLANKET', 2,
696: 1),
697: fl.meaning, -- begin
698: pll.quantity,

Line 993: 'STANDARD', 1,

989: msi.volume_uom_code,
990: rsh.ship_to_org_id,
991: poh.segment1,
992: DECODE( poh.type_lookup_code,
993: 'STANDARD', 1,
994: 'BLANKET', 2,
995: 1),
996: fl.meaning,
997: pll.quantity,

Line 1262: -- Get data for delivery record from Approved Standard Purchase Order

1258: -- None.
1259: --Locks:
1260: -- None.
1261: --Function:
1262: -- Get data for delivery record from Approved Standard Purchase Order
1263: --Parameters:
1264: --IN:
1265: --p_api_version
1266: -- Specifies API version.

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

1292: l_api_name CONSTANT VARCHAR2(100) := 'get_approved_po';
1293: l_api_version CONSTANT NUMBER := 1.0;
1294:
1295: BEGIN
1296: -- Standard call to check for call compatibility.
1297: IF NOT FND_API.Compatible_API_Call
1298: (
1299: p_current_version_number => l_api_version,
1300: p_caller_version_number => p_api_version,

Line 1309: -- Approved Standard PO, Standard PO referencing GA or Contract

1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1306: END IF;
1307:
1308: -- The following is for query data for delivery record from:
1309: -- Approved Standard PO, Standard PO referencing GA or Contract
1310:
1311: --SQL What: Querying data from Approved Standard PO of quantity
1312: --SQL based items.
1313: --SQL Where: MSI.inventory_item_id (+) = POL.item_id

Line 1311: --SQL What: Querying data from Approved Standard PO of quantity

1307:
1308: -- The following is for query data for delivery record from:
1309: -- Approved Standard PO, Standard PO referencing GA or Contract
1310:
1311: --SQL What: Querying data from Approved Standard PO of quantity
1312: --SQL based items.
1313: --SQL Where: MSI.inventory_item_id (+) = POL.item_id
1314: --SQL NVL(MSI.organization_id, POLL.ship_to_organization_id)
1315: --SQL = POLL.ship_to_organization_id

Line 1484: -- Get data for delivery record from Cancelled Standard Purchase Order

1480: -- None.
1481: --Locks:
1482: -- None.
1483: --Function:
1484: -- Get data for delivery record from Cancelled Standard Purchase Order
1485: --Parameters:
1486: --IN:
1487: --p_api_version
1488: -- Specifies API version.

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

1514: l_api_name CONSTANT VARCHAR2(100) := 'get_cancelled_po';
1515: l_api_version CONSTANT NUMBER := 1.0;
1516:
1517: BEGIN
1518: -- Standard call to check for call compatibility.
1519: IF NOT FND_API.Compatible_API_Call
1520: (
1521: p_current_version_number => l_api_version,
1522: p_caller_version_number => p_api_version,

Line 1531: -- Cancelled Standard PO, Standard PO referencing GA or Contract

1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: END IF;
1529:
1530: -- The following is for query data for delivery record from:
1531: -- Cancelled Standard PO, Standard PO referencing GA or Contract
1532:
1533: --SQL What: Querying data from Cancelled Standard PO of quantity
1534: --SQL based items.
1535: --SQL Where: MSI.inventory_item_id (+) = POL.item_id

Line 1533: --SQL What: Querying data from Cancelled Standard PO of quantity

1529:
1530: -- The following is for query data for delivery record from:
1531: -- Cancelled Standard PO, Standard PO referencing GA or Contract
1532:
1533: --SQL What: Querying data from Cancelled Standard PO of quantity
1534: --SQL based items.
1535: --SQL Where: MSI.inventory_item_id (+) = POL.item_id
1536: --SQL NVL(MSI.organization_id, POLL.ship_to_organization_id)
1537: --SQL = POLL.ship_to_organization_id

Line 1705: -- Get data for delivery record from Opened Standard Purchase Order

1701: -- None.
1702: --Locks:
1703: -- None.
1704: --Function:
1705: -- Get data for delivery record from Opened Standard Purchase Order
1706: --Parameters:
1707: --IN:
1708: --p_api_version
1709: -- Specifies API version.

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

1735: l_api_name CONSTANT VARCHAR2(100) := 'get_opened_po';
1736: l_api_version CONSTANT NUMBER := 1.0;
1737:
1738: BEGIN
1739: -- Standard call to check for call compatibility.
1740: IF NOT FND_API.Compatible_API_Call
1741: (
1742: p_current_version_number => l_api_version,
1743: p_caller_version_number => p_api_version,

Line 1752: -- Opened Standard PO, Standard PO referencing GA or Contract

1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: END IF;
1750:
1751: -- The following is for query data for delivery record from:
1752: -- Opened Standard PO, Standard PO referencing GA or Contract
1753:
1754: --SQL What: Querying data from Opened Standard PO of quantity
1755: --SQL based items.
1756: --SQL Where: MSI.inventory_item_id (+) = POL.item_id

Line 1754: --SQL What: Querying data from Opened Standard PO of quantity

1750:
1751: -- The following is for query data for delivery record from:
1752: -- Opened Standard PO, Standard PO referencing GA or Contract
1753:
1754: --SQL What: Querying data from Opened Standard PO of quantity
1755: --SQL based items.
1756: --SQL Where: MSI.inventory_item_id (+) = POL.item_id
1757: --SQL NVL(MSI.organization_id, POLL.ship_to_organization_id)
1758: --SQL = POLL.ship_to_organization_id

Line 1927: -- Get data for delivery record from Closed Standard Purchase Order

1923: -- None.
1924: --Locks:
1925: -- None.
1926: --Function:
1927: -- Get data for delivery record from Closed Standard Purchase Order
1928: --Parameters:
1929: --IN:
1930: --p_api_version
1931: -- Specifies API version.

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

1957: l_api_name CONSTANT VARCHAR2(100) := 'get_closed_po';
1958: l_api_version CONSTANT NUMBER := 1.0;
1959:
1960: BEGIN
1961: -- Standard call to check for call compatibility.
1962: IF NOT FND_API.Compatible_API_Call
1963: (
1964: p_current_version_number => l_api_version,
1965: p_caller_version_number => p_api_version,

Line 1974: -- Closed Standard PO, Standard PO referencing GA or Contract

1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: -- The following is for query data for delivery record from:
1974: -- Closed Standard PO, Standard PO referencing GA or Contract
1975:
1976: --SQL What: Querying data from Closed Standard PO of quantity
1977: --SQL based items.
1978: --SQL Where: MSI.inventory_item_id (+) = POL.item_id

Line 1976: --SQL What: Querying data from Closed Standard PO of quantity

1972:
1973: -- The following is for query data for delivery record from:
1974: -- Closed Standard PO, Standard PO referencing GA or Contract
1975:
1976: --SQL What: Querying data from Closed Standard PO of quantity
1977: --SQL based items.
1978: --SQL Where: MSI.inventory_item_id (+) = POL.item_id
1979: --SQL NVL(MSI.organization_id, POLL.ship_to_organization_id)
1980: --SQL = POLL.ship_to_organization_id

Line 2149: -- Get data for delivery record from Finally Closed Standard Purchase Order

2145: -- None.
2146: --Locks:
2147: -- None.
2148: --Function:
2149: -- Get data for delivery record from Finally Closed Standard Purchase Order
2150: --Parameters:
2151: --IN:
2152: --p_api_version
2153: -- Specifies API version.

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

2179: l_api_name CONSTANT VARCHAR2(100) := 'get_finally_closed_po';
2180: l_api_version CONSTANT NUMBER := 1.0;
2181:
2182: BEGIN
2183: -- Standard call to check for call compatibility.
2184: IF NOT FND_API.Compatible_API_Call
2185: (
2186: p_current_version_number => l_api_version,
2187: p_caller_version_number => p_api_version,

Line 2196: -- Finally Closed Standard PO, Standard PO referencing GA or Contract

2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: END IF;
2194:
2195: -- The following is for query data for delivery record from:
2196: -- Finally Closed Standard PO, Standard PO referencing GA or Contract
2197:
2198: --SQL What: Querying data from Finally Closed Standard PO of
2199: --SQL quantity based items.
2200: --SQL Where: MSI.inventory_item_id (+) = POL.item_id

Line 2198: --SQL What: Querying data from Finally Closed Standard PO of

2194:
2195: -- The following is for query data for delivery record from:
2196: -- Finally Closed Standard PO, Standard PO referencing GA or Contract
2197:
2198: --SQL What: Querying data from Finally Closed Standard PO of
2199: --SQL quantity based items.
2200: --SQL Where: MSI.inventory_item_id (+) = POL.item_id
2201: --SQL NVL(MSI.organization_id, POLL.ship_to_organization_id)
2202: --SQL = POLL.ship_to_organization_id

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

2397: l_api_name CONSTANT VARCHAR2(100) := 'get_approved_release';
2398: l_api_version CONSTANT NUMBER := 1.0;
2399:
2400: BEGIN
2401: -- Standard call to check for call compatibility.
2402: IF NOT FND_API.Compatible_API_Call
2403: (
2404: p_current_version_number => l_api_version,
2405: p_caller_version_number => p_api_version,

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

2625: l_api_name CONSTANT VARCHAR2(100) := 'get_cancelled_release';
2626: l_api_version CONSTANT NUMBER := 1.0;
2627:
2628: BEGIN
2629: -- Standard call to check for call compatibility.
2630: IF NOT FND_API.Compatible_API_Call
2631: (
2632: p_current_version_number => l_api_version,
2633: p_caller_version_number => p_api_version,

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

2851: l_api_name CONSTANT VARCHAR2(100) := 'get_opened_release';
2852: l_api_version CONSTANT NUMBER := 1.0;
2853:
2854: BEGIN
2855: -- Standard call to check for call compatibility.
2856: IF NOT FND_API.Compatible_API_Call
2857: (
2858: p_current_version_number => l_api_version,
2859: p_caller_version_number => p_api_version,

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

3078: l_api_name CONSTANT VARCHAR2(100) := 'get_closed_release';
3079: l_api_version CONSTANT NUMBER := 1.0;
3080:
3081: BEGIN
3082: -- Standard call to check for call compatibility.
3083: IF NOT FND_API.Compatible_API_Call
3084: (
3085: p_current_version_number => l_api_version,
3086: p_caller_version_number => p_api_version,

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

3307: l_api_name CONSTANT VARCHAR2(100) := 'get_finally_closed_release';
3308: l_api_version CONSTANT NUMBER := 1.0;
3309:
3310: BEGIN
3311: -- Standard call to check for call compatibility.
3312: IF NOT FND_API.Compatible_API_Call
3313: (
3314: p_current_version_number => l_api_version,
3315: p_caller_version_number => p_api_version,