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.INV_RCV_COMMON_APIS dependencies on STANDARD

Line 95: -- for testing only ?? need INV standard api for this

91: BEGIN
92: return length(p_from_ser);
93: END get_serial_length;
94:
95: -- for testing only ?? need INV standard api for this
96: FUNCTION get_to_serial_number(p_from_ser VARCHAR2, p_primary_quantity NUMBER)
97: RETURN VARCHAR2 IS
98: l_to_ser VARCHAR2(30);
99: l_number NUMBER;

Line 628: -- need standard INV api to replace this func

624: IF (l_primary_quantity > l_new_primary_quantity) -- new quantity detailed completely
625: -- and there is remaining ser qty
626: THEN
627: l_msnt_rec.transaction_temp_id := l_new_transaction_temp_id;
628: -- need standard INV api to replace this func
629: l_msnt_rec.to_serial_number := get_to_serial_number(l_from_ser, l_new_primary_quantity);
630: insert_msnt(l_msnt_rec); -- insert one line with new to-ser-number and new txn_id
631: -- Update the existing ser rec with start serial number ??
632: l_new_ser := get_to_serial_number(l_from_ser, l_new_primary_quantity + 1);

Line 1979: * else (all line detail are standard) the entire PO is standard

1975: * Routing ID is defined at PO line-location level (po_line_locations_all)
1976: * We use the following rule to set headers routing ID
1977: * If there is one line detail needs inspection the entire PO needs inspection
1978: * elsif there is one line detail needs direct receiving the entire PO direct
1979: * else (all line detail are standard) the entire PO is standard
1980: * rounting lookups: 1. standard 2. Inspect 3. Direct
1981: ******************************************************/
1982: PROCEDURE get_po_routing_id(
1983: x_po_routing_id OUT NOCOPY NUMBER

Line 1980: * rounting lookups: 1. standard 2. Inspect 3. Direct

1976: * We use the following rule to set headers routing ID
1977: * If there is one line detail needs inspection the entire PO needs inspection
1978: * elsif there is one line detail needs direct receiving the entire PO direct
1979: * else (all line detail are standard) the entire PO is standard
1980: * rounting lookups: 1. standard 2. Inspect 3. Direct
1981: ******************************************************/
1982: PROCEDURE get_po_routing_id(
1983: x_po_routing_id OUT NOCOPY NUMBER
1984: , x_is_expense OUT NOCOPY VARCHAR2

Line 2020: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

2016: AND NVL(poll.approved_flag, 'N') = 'Y'
2017: AND NVL(poll.cancel_flag, 'N') = 'N'
2018: AND NVL(poll.closed_code, 'OPEN')NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2019: /*Fix for bug #4755862*/
2020: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2021: UNION ALL
2022: SELECT poll.receiving_routing_id
2023: -- p_po_release_id is null and p_po_line_id is not null
2024: FROM po_line_locations poll, po_lines pol

Line 2035: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

2031: AND NVL(poll.approved_flag, 'N') = 'Y'
2032: AND NVL(poll.cancel_flag, 'N') = 'N'
2033: AND NVL(poll.closed_code, 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2034: /*Fix for bug #4755862*/
2035: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2036: UNION ALL
2037: SELECT poll.receiving_routing_id
2038: -- p_po_release_id is not null
2039: FROM po_line_locations poll, po_lines pol

Line 2050: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');

2046: AND NVL(poll.approved_flag, 'N') = 'Y'
2047: AND NVL(poll.cancel_flag, 'N') = 'N'
2048: AND NVL(poll.closed_code, 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2049: /*Fix for bug #4755862*/
2050: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');
2051: /*
2052: SELECT poll.receiving_routing_id
2053: FROM po_line_locations poll, po_lines pol
2054: WHERE poll.po_header_id = p_po_header_id

Line 2068: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');

2064: AND pol.po_line_id = poll.po_line_id
2065: AND NVL(poll.approved_flag, 'N') = 'Y'
2066: AND NVL(poll.cancel_flag, 'N') = 'N'
2067: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2068: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2069: */
2070:
2071: CURSOR pod_dest_context_cur IS
2072: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)

Line 2085: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )

2081: AND POL.ITEM_ID IS NULL AND POL.ITEM_DESCRIPTION = p_item_desc ))
2082: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2083: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2084: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2085: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2086: UNION ALL
2087: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2088: -- p_po_release_id is null and p_po_line_id is not null
2089: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

Line 2100: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )

2096: AND POL.ITEM_ID IS NULL AND POL.ITEM_DESCRIPTION = p_item_desc ))
2097: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2098: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2099: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2100: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2101: UNION ALL
2102: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2103: -- p_po_release_id is not NULL
2104: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

Line 2115: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' );

2111: AND pol.item_id IS NULL AND pol.item_description = p_item_desc))
2112: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2113: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2114: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2115: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' );
2116: /*
2117: SELECT DISTINCT Nvl(pod.destination_type_code,pod.destination_context)
2118: FROM po_distributions pod, po_lines pol, po_line_locations poll
2119: WHERE pod.po_header_id = p_po_header_id

Line 2134: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');

2130: AND pol.po_line_id = poll.po_line_id
2131: AND NVL(poll.approved_flag, 'N') = 'Y'
2132: AND NVL(poll.cancel_flag, 'N') = 'N'
2133: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2134: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2135: */
2136:
2137: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2138: BEGIN

Line 2161: ELSIF l_po_ll_routing_id = 1 THEN -- standard

2157:
2158: IF l_po_ll_routing_id = 2 THEN -- inspection
2159: l_po_routing_id := 2;
2160: EXIT; -- inspection overrides everything
2161: ELSIF l_po_ll_routing_id = 1 THEN -- standard
2162: l_po_routing_id := 1; -- standard overrides direct
2163: ELSIF(l_po_ll_routing_id = 3
2164: AND NVL(l_po_routing_id, 3) >= 3) THEN -- direct
2165: l_po_routing_id := 3; -- direct is default if not null

Line 2162: l_po_routing_id := 1; -- standard overrides direct

2158: IF l_po_ll_routing_id = 2 THEN -- inspection
2159: l_po_routing_id := 2;
2160: EXIT; -- inspection overrides everything
2161: ELSIF l_po_ll_routing_id = 1 THEN -- standard
2162: l_po_routing_id := 1; -- standard overrides direct
2163: ELSIF(l_po_ll_routing_id = 3
2164: AND NVL(l_po_routing_id, 3) >= 3) THEN -- direct
2165: l_po_routing_id := 3; -- direct is default if not null
2166: END IF;

Line 2414: * else (all line detail are standard) the entire shipment is standard

2410: * Routing ID is defined at shipment line level (rcv_shipment_lines)
2411: * We use the following rule to set headers routing ID
2412: * If there is one line detail needs inspection the entire shipment needs inspection
2413: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2414: * else (all line detail are standard) the entire shipment is standard
2415: * rounting lookups: 1. standard 2. Inspect 3. Direct
2416: ******************************************************/
2417: PROCEDURE get_intshp_routing_id(
2418: x_intshp_routing_id OUT NOCOPY NUMBER

Line 2415: * rounting lookups: 1. standard 2. Inspect 3. Direct

2411: * We use the following rule to set headers routing ID
2412: * If there is one line detail needs inspection the entire shipment needs inspection
2413: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2414: * else (all line detail are standard) the entire shipment is standard
2415: * rounting lookups: 1. standard 2. Inspect 3. Direct
2416: ******************************************************/
2417: PROCEDURE get_intshp_routing_id(
2418: x_intshp_routing_id OUT NOCOPY NUMBER
2419: , x_is_expense OUT NOCOPY VARCHAR2

Line 2462: ELSIF l_intshp_routing_id = 1 THEN -- standard

2458:
2459: IF l_intshp_routing_id = 2 THEN -- inspection
2460: l_intran_routing_id := 2;
2461: EXIT; -- inspection overrides everything
2462: ELSIF l_intshp_routing_id = 1 THEN -- standard
2463: l_intran_routing_id := 1; -- standard overrides direct
2464: ELSIF(l_intshp_routing_id = 3
2465: AND NVL(l_intran_routing_id, 3) >= 3) THEN -- direct
2466: l_intran_routing_id := 3; -- direct is default if not null

Line 2463: l_intran_routing_id := 1; -- standard overrides direct

2459: IF l_intshp_routing_id = 2 THEN -- inspection
2460: l_intran_routing_id := 2;
2461: EXIT; -- inspection overrides everything
2462: ELSIF l_intshp_routing_id = 1 THEN -- standard
2463: l_intran_routing_id := 1; -- standard overrides direct
2464: ELSIF(l_intshp_routing_id = 3
2465: AND NVL(l_intran_routing_id, 3) >= 3) THEN -- direct
2466: l_intran_routing_id := 3; -- direct is default if not null
2467: END IF;

Line 2531: * rounting lookups: 1. standard 2. Inspect 3. Direct

2527: * It first uses the item level value
2528: * if that is null then it uses the vendor level value
2529: * even if that is null it uses the org level value which if null is = 1
2530: * We use the following rule to set headers routing ID
2531: * rounting lookups: 1. standard 2. Inspect 3. Direct
2532: ******************************************************/
2533: PROCEDURE get_default_routing_id(
2534: x_default_routing_id OUT NOCOPY NUMBER
2535: , p_item_id IN NUMBER

Line 3532: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

3528: WHERE poll.po_header_id = po.po_header_id
3529: AND Nvl(poll.approved_flag,'N') = 'Y'
3530: AND Nvl(poll.cancel_flag,'N') = 'N'
3531: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
3532: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
3533: AND poll.ship_to_organization_id = p_organization_id
3534: AND poll.po_line_id = po.po_line_id
3535: AND po.po_header_id = p_po_header_id)
3536: AND ROWNUM=1;

Line 3569: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

3565: WHERE poll.po_header_id = po.po_header_id
3566: AND Nvl(poll.approved_flag,'N') = 'Y'
3567: AND Nvl(poll.cancel_flag,'N') = 'N'
3568: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
3569: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
3570: AND poll.ship_to_organization_id = p_organization_id
3571: AND poll.po_line_id = po.po_line_id
3572: AND po.po_header_id = p_po_header_id)
3573: AND ROWNUM=1;

Line 3607: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

3603: WHERE poll.po_header_id = po.po_header_id
3604: AND Nvl(poll.approved_flag,'N') = 'Y'
3605: AND Nvl(poll.cancel_flag,'N') = 'N'
3606: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
3607: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
3608: AND poll.ship_to_organization_id = p_organization_id
3609: AND poll.po_line_id = po.po_line_id
3610: AND po.item_id = p_item_id
3611: AND po.po_header_id = p_po_header_id);

Line 3636: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

3632: WHERE poll.po_header_id = po.po_header_id
3633: AND Nvl(poll.approved_flag,'N') = 'Y'
3634: AND Nvl(poll.cancel_flag,'N') = 'N'
3635: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
3636: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
3637: AND poll.ship_to_organization_id = p_organization_id
3638: AND poll.po_line_id = po.po_line_id
3639: AND po.item_id = p_item_id
3640: AND po.po_header_id = p_po_header_id)

Line 4206: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED');

4202: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
4203: AND Nvl(poll.approved_flag,'N') = 'Y'
4204: AND Nvl(poll.cancel_flag,'N') = 'N'
4205: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4206: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED');
4207:
4208: l_progress :='20';
4209: IF (l_debug = 1) THEN
4210: print_debug('Checking the value for location: ' || x_location_code, 4);

Line 4328: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED');

4324: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
4325: AND Nvl(poll.approved_flag,'N') = 'Y'
4326: AND Nvl(poll.cancel_flag,'N') = 'N'
4327: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4328: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED');
4329:
4330:
4331: ELSIF p_document_type IN ( 'REQ', 'INTSHIP' ,'ASN') THEN
4332: