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 2027: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

2023: AND NVL(poll.approved_flag, 'N') = 'Y'
2024: AND NVL(poll.cancel_flag, 'N') = 'N'
2025: AND NVL(poll.closed_code, 'OPEN')NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2026: /*Fix for bug #4755862*/
2027: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2028: UNION ALL
2029: SELECT poll.receiving_routing_id
2030: -- p_po_release_id is null and p_po_line_id is not null
2031: FROM po_line_locations poll, po_lines pol

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

2038: AND NVL(poll.approved_flag, 'N') = 'Y'
2039: AND NVL(poll.cancel_flag, 'N') = 'N'
2040: AND NVL(poll.closed_code, 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2041: /*Fix for bug #4755862*/
2042: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2043: UNION ALL
2044: SELECT poll.receiving_routing_id
2045: -- p_po_release_id is not null
2046: FROM po_line_locations poll, po_lines pol

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

2053: AND NVL(poll.approved_flag, 'N') = 'Y'
2054: AND NVL(poll.cancel_flag, 'N') = 'N'
2055: AND NVL(poll.closed_code, 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2056: /*Fix for bug #4755862*/
2057: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');
2058: /*
2059: SELECT poll.receiving_routing_id
2060: FROM po_line_locations poll, po_lines pol
2061: WHERE poll.po_header_id = p_po_header_id

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

2071: AND pol.po_line_id = poll.po_line_id
2072: AND NVL(poll.approved_flag, 'N') = 'Y'
2073: AND NVL(poll.cancel_flag, 'N') = 'N'
2074: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2075: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2076: */
2077:
2078: CURSOR pod_dest_context_cur IS
2079: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)

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

2091: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2092: /*Added for Bug#7281141- getting the distributions against only the open line locations
2093: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' */
2094: AND NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2095: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2096: UNION ALL
2097: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2098: -- p_po_release_id is null and p_po_line_id is not null
2099: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

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

2109: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2110: /*Added for Bug#7281141- getting the distributions against only the open line locations
2111: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' */
2112: AND NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED')
2113: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2114: UNION ALL
2115: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2116: -- p_po_release_id is not NULL
2117: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

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

2125: AND pol.item_id IS NULL AND pol.item_description = p_item_desc))
2126: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2127: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2128: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2129: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' );
2130:
2131: -- Bug 8242448 - Code changes start
2132:
2133: -- As part of bug # 7281141, the cursor 'pod_dest_context_cur' is modified to fetch the

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

2151: AND POL.ITEM_ID IS NULL AND POL.ITEM_DESCRIPTION = p_item_desc ))
2152: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2153: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2154: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2155: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2156: UNION ALL
2157: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2158: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2159: WHERE POLL.PO_HEADER_ID = p_po_header_id

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

2166: AND POL.ITEM_ID IS NULL AND POL.ITEM_DESCRIPTION = p_item_desc ))
2167: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2168: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2169: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2170: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2171: UNION ALL
2172: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2173: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2174: WHERE POLL.PO_HEADER_ID = p_po_header_id

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

2181: AND pol.item_id IS NULL AND pol.item_description = p_item_desc))
2182: AND NVL(POLL.APPROVED_FLAG,'N') = 'Y'
2183: AND NVL(POLL.CANCEL_FLAG,'N') = 'N'
2184: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2185: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' );
2186:
2187: -- Bug 8242448 - Code changes end
2188:
2189: /*

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

2203: AND pol.po_line_id = poll.po_line_id
2204: AND NVL(poll.approved_flag, 'N') = 'Y'
2205: AND NVL(poll.cancel_flag, 'N') = 'N'
2206: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2207: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2208: */
2209:
2210: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2211: BEGIN

Line 2236: ELSIF l_po_ll_routing_id = 1 THEN -- standard

2232:
2233: IF l_po_ll_routing_id = 2 THEN -- inspection
2234: l_po_routing_id := 2;
2235: EXIT; -- inspection overrides everything
2236: ELSIF l_po_ll_routing_id = 1 THEN -- standard
2237: l_po_routing_id := 1; -- standard overrides direct
2238: ELSIF(l_po_ll_routing_id = 3
2239: AND NVL(l_po_routing_id, 3) >= 3) THEN -- direct
2240: l_po_routing_id := 3; -- direct is default if not null

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

2233: IF l_po_ll_routing_id = 2 THEN -- inspection
2234: l_po_routing_id := 2;
2235: EXIT; -- inspection overrides everything
2236: ELSIF l_po_ll_routing_id = 1 THEN -- standard
2237: l_po_routing_id := 1; -- standard overrides direct
2238: ELSIF(l_po_ll_routing_id = 3
2239: AND NVL(l_po_routing_id, 3) >= 3) THEN -- direct
2240: l_po_routing_id := 3; -- direct is default if not null
2241: END IF;

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

2545: * Routing ID is defined at shipment line level (rcv_shipment_lines)
2546: * We use the following rule to set headers routing ID
2547: * If there is one line detail needs inspection the entire shipment needs inspection
2548: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2549: * else (all line detail are standard) the entire shipment is standard
2550: * rounting lookups: 1. standard 2. Inspect 3. Direct
2551: ******************************************************/
2552: PROCEDURE get_intshp_routing_id(
2553: x_intshp_routing_id OUT NOCOPY NUMBER

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

2546: * We use the following rule to set headers routing ID
2547: * If there is one line detail needs inspection the entire shipment needs inspection
2548: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2549: * else (all line detail are standard) the entire shipment is standard
2550: * rounting lookups: 1. standard 2. Inspect 3. Direct
2551: ******************************************************/
2552: PROCEDURE get_intshp_routing_id(
2553: x_intshp_routing_id OUT NOCOPY NUMBER
2554: , x_is_expense OUT NOCOPY VARCHAR2

Line 2603: ELSIF l_intshp_routing_id = 1 THEN -- standard

2599:
2600: IF l_intshp_routing_id = 2 THEN -- inspection
2601: l_intran_routing_id := 2;
2602: EXIT; -- inspection overrides everything
2603: ELSIF l_intshp_routing_id = 1 THEN -- standard
2604: l_intran_routing_id := 1; -- standard overrides direct
2605: ELSIF(l_intshp_routing_id = 3
2606: AND NVL(l_intran_routing_id, 3) >= 3) THEN -- direct
2607: l_intran_routing_id := 3; -- direct is default if not null

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

2600: IF l_intshp_routing_id = 2 THEN -- inspection
2601: l_intran_routing_id := 2;
2602: EXIT; -- inspection overrides everything
2603: ELSIF l_intshp_routing_id = 1 THEN -- standard
2604: l_intran_routing_id := 1; -- standard overrides direct
2605: ELSIF(l_intshp_routing_id = 3
2606: AND NVL(l_intran_routing_id, 3) >= 3) THEN -- direct
2607: l_intran_routing_id := 3; -- direct is default if not null
2608: END IF;

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

2669: * It first uses the item level value
2670: * if that is null then it uses the vendor level value
2671: * even if that is null it uses the org level value which if null is = 1
2672: * We use the following rule to set headers routing ID
2673: * rounting lookups: 1. standard 2. Inspect 3. Direct
2674: ******************************************************/
2675: PROCEDURE get_default_routing_id(
2676: x_default_routing_id OUT NOCOPY NUMBER
2677: , p_item_id IN NUMBER

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

4011: WHERE poll.po_header_id = po.po_header_id
4012: AND Nvl(poll.approved_flag,'N') = 'Y'
4013: AND Nvl(poll.cancel_flag,'N') = 'N'
4014: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4015: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
4016: AND poll.ship_to_organization_id = p_organization_id
4017: AND poll.po_line_id = po.po_line_id
4018: AND po.po_header_id = p_po_header_id)
4019: AND ROWNUM=1;

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

4048: WHERE poll.po_header_id = po.po_header_id
4049: AND Nvl(poll.approved_flag,'N') = 'Y'
4050: AND Nvl(poll.cancel_flag,'N') = 'N'
4051: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4052: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
4053: AND poll.ship_to_organization_id = p_organization_id
4054: AND poll.po_line_id = po.po_line_id
4055: AND po.po_header_id = p_po_header_id)
4056: AND ROWNUM=1;

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

4086: WHERE poll.po_header_id = po.po_header_id
4087: AND Nvl(poll.approved_flag,'N') = 'Y'
4088: AND Nvl(poll.cancel_flag,'N') = 'N'
4089: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4090: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
4091: AND poll.ship_to_organization_id = p_organization_id
4092: AND poll.po_line_id = po.po_line_id
4093: AND po.item_id = p_item_id
4094: AND po.po_header_id = p_po_header_id);

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

4115: WHERE poll.po_header_id = po.po_header_id
4116: AND Nvl(poll.approved_flag,'N') = 'Y'
4117: AND Nvl(poll.cancel_flag,'N') = 'N'
4118: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4119: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
4120: AND poll.ship_to_organization_id = p_organization_id
4121: AND poll.po_line_id = po.po_line_id
4122: AND po.item_id = p_item_id
4123: AND po.po_header_id = p_po_header_id)

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

4722: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
4723: AND Nvl(poll.approved_flag,'N') = 'Y'
4724: AND Nvl(poll.cancel_flag,'N') = 'N'
4725: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4726: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
4727: AND Nvl(pol.item_id,-9999) = NVL(p_item_id,Nvl(pol.item_id,-9999)); --BUG 4500676
4728: /* end bug 14305407*/
4729: END IF; -- bug 864331
4730:

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

4847: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
4848: AND Nvl(poll.approved_flag,'N') = 'Y'
4849: AND Nvl(poll.cancel_flag,'N') = 'N'
4850: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')
4851: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED');
4852:
4853:
4854: ELSIF p_document_type IN ( 'REQ', 'INTSHIP' ,'ASN') THEN
4855: