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.OE_HOLDS_PUB dependencies on OE_HOLD_SOURCES

Line 22: p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

18:
19:
20: FUNCTION Hold_Site_Code (
21: --ER#7479609 p_hold_entity_id IN NUMBER
22: p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
23: )
24: RETURN VARCHAR2
25: IS
26: l_site_use_code varchar2(30);

Line 106: UPDATE OE_HOLD_SOURCES

102:
103: If p_hold_source_rec.HOLD_SOURCE_ID is NOT NULL THEN
104:
105: --ER 12363706, WHO Columns added
106: UPDATE OE_HOLD_SOURCES
107: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
108: LAST_UPDATE_DATE = SYSDATE,
109: LAST_UPDATED_BY = FND_GLOBAL.user_id
110: WHERE HOLD_SOURCE_ID = p_hold_source_rec.HOLD_SOURCE_ID;

Line 118: UPDATE OE_HOLD_SOURCES

114:
115: if (p_hold_source_rec.HOLD_ENTITY_CODE2 is NOT NULL AND
116: p_hold_source_rec.HOLD_ENTITY_ID2 is NOT NULL) THEN
117: --ER 12363706, WHO Columns added
118: UPDATE OE_HOLD_SOURCES
119: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
120: LAST_UPDATE_DATE = SYSDATE,
121: LAST_UPDATED_BY = FND_GLOBAL.user_id
122: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE

Line 134: UPDATE OE_HOLD_SOURCES HS

130: else
131: /* Check to see if its a line-level hold */
132: if p_hold_source_rec.line_id is not null then
133: --ER 12363706, WHO Columns added
134: UPDATE OE_HOLD_SOURCES HS
135: SET HS.HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
136: HS.LAST_UPDATE_DATE = SYSDATE,
137: HS.LAST_UPDATED_BY = FND_GLOBAL.user_id
138:

Line 152: UPDATE OE_HOLD_SOURCES

148: WHERE OH.LINE_ID = p_hold_source_rec.line_id
149: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID);
150: else
151: --ER 12363706, WHO Columns added
152: UPDATE OE_HOLD_SOURCES
153: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
154: LAST_UPDATE_DATE = SYSDATE,
155: LAST_UPDATED_BY = FND_GLOBAL.user_id
156: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE

Line 241: from oe_hold_sources

237: l_curr_org_id number;
238:
239: CURSOR expired_holds_cur IS
240: select hold_source_id, ORG_ID
241: from oe_hold_sources
242: where HOLD_UNTIL_DATE <= sysdate
243: and released_flag = 'N';
244: --
245: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 358: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

354: (p_header_id IN NUMBER DEFAULT NULL
355: , p_line_id IN NUMBER DEFAULT NULL
356: , p_hold_entity_code IN VARCHAR2
357: --ER#7479609 , p_hold_entity_id IN NUMBER
358: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
359: , p_hold_entity_code2 IN VARCHAR2
360: --ER#7479609 , p_hold_entity_id2 IN NUMBER
361: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE --ER#7479609
362: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 361: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE --ER#7479609

357: --ER#7479609 , p_hold_entity_id IN NUMBER
358: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
359: , p_hold_entity_code2 IN VARCHAR2
360: --ER#7479609 , p_hold_entity_id2 IN NUMBER
361: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE --ER#7479609
362: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
363: )
364: IS
365: l_api_name CONSTANT VARCHAR2(30) := 'ValidateOrder';

Line 623: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,

619: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
620: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
621: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
622: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
623: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
624: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
625: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
626: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
627: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 624: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,

620: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
621: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
622: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
623: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
624: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
625: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
626: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
627: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
628: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 1000: , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC

996: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
997: , p_header_id IN NUMBER DEFAULT NULL
998: , p_line_id IN NUMBER DEFAULT NULL
999: , p_hold_source_id IN NUMBER DEFAULT NULL
1000: , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC
1001: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC
1002: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
1003: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1004: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1001: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC

997: , p_header_id IN NUMBER DEFAULT NULL
998: , p_line_id IN NUMBER DEFAULT NULL
999: , p_hold_source_id IN NUMBER DEFAULT NULL
1000: , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC
1001: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC
1002: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
1003: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1004: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1005: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1015: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

1011: l_hold_source_id NUMBER := 0;
1012: l_dummy VARCHAR2(30);
1013: l_order_holds_s NUMBER := 0;
1014: --ER#7479609 l_entity_code VARCHAR2(1);
1015: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
1016: l_entity_id NUMBER;
1017: --
1018: --ER#7479609 l_entity_code2 VARCHAR2(1);
1019: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

Line 1019: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

1015: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
1016: l_entity_id NUMBER;
1017: --
1018: --ER#7479609 l_entity_code2 VARCHAR2(1);
1019: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
1020: l_entity_id2 NUMBER;
1021: l_header_id NUMBER DEFAULT NULL;
1022:
1023: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

Line 1073: FROM OE_HOLD_SOURCES

1069: SELECT HOLD_ENTITY_CODE, HOLD_ENTITY_ID,
1070: HOLD_ENTITY_CODE2, HOLD_ENTITY_ID2
1071: INTO l_entity_code, l_entity_id,
1072: l_entity_code2, l_entity_id2
1073: FROM OE_HOLD_SOURCES
1074: WHERE HOLD_SOURCE_ID = p_hold_source_id
1075: AND RELEASED_FLAG = 'N'
1076: AND NVL(HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE;
1077:

Line 1290: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

1286: , p_wf_item IN VARCHAR2 DEFAULT NULL
1287: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1288: , p_entity_code IN VARCHAR2 DEFAULT NULL
1289: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1290: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1291: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1292: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1293: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1294: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 1293: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

1289: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1290: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1291: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1292: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1293: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1294: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1295: , p_ii_parent_flag IN VARCHAR2 DEFAULT 'N'
1296: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1297: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1340: FROM oe_hold_sources_all hs,

1336: and oh.line_id = p_line_id
1337: and oh.hold_release_id is null
1338: AND EXISTS
1339: (SELECT 1
1340: FROM oe_hold_sources_all hs,
1341: oe_hold_definitions h
1342: WHERE oh.hold_source_id = hs.hold_source_id
1343: AND hs.hold_id = h.hold_id
1344: AND NVL(h.item_type,

Line 1428: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

1424: , p_wf_item IN VARCHAR2 DEFAULT NULL
1425: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1426: , p_entity_code IN VARCHAR2 DEFAULT NULL
1427: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1428: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1429: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1430: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1431: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1432: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 1431: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

1427: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1428: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1429: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1430: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1431: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1432: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1433: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1434: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1435: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1470: FROM oe_hold_sources_all hs,

1466: and ol.top_model_line_id = p_top_model_line_id)
1467: and oh.hold_release_id is null
1468: AND EXISTS
1469: (SELECT 1
1470: FROM oe_hold_sources_all hs,
1471: oe_hold_definitions h
1472: WHERE oh.hold_source_id = hs.hold_source_id
1473: AND hs.hold_id = h.hold_id
1474: AND NVL(h.item_type,

Line 1555: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

1551: , p_wf_item IN VARCHAR2 DEFAULT NULL
1552: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1553: , p_entity_code IN VARCHAR2 DEFAULT NULL
1554: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1555: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1556: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1557: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1558: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1559: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 1558: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

1554: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1555: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1556: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1557: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1558: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1559: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1560: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1561: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1562: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1596: FROM oe_hold_sources_all hs,

1592: and ol.top_model_line_id = p_top_model_line_id)
1593: and oh.hold_release_id is null
1594: AND EXISTS
1595: (SELECT 1
1596: FROM oe_hold_sources_all hs,
1597: oe_hold_definitions h
1598: WHERE oh.hold_source_id = hs.hold_source_id
1599: AND hs.hold_id = h.hold_id
1600: AND NVL(h.item_type,

Line 1704: FROM oe_hold_sources_all hs,

1700: and OH.HOLD_RELEASE_ID IS NULL
1701: and ROWNUM = 1
1702: AND EXISTS
1703: (SELECT 1
1704: FROM oe_hold_sources_all hs,
1705: oe_hold_definitions h
1706: WHERE oh.hold_source_id = hs.hold_source_id
1707: AND hs.hold_id = h.hold_id
1708: AND NVL(h.item_type,

Line 1796: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

1792: , p_wf_item IN VARCHAR2 DEFAULT NULL
1793: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1794: , p_entity_code IN VARCHAR2 DEFAULT NULL
1795: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1796: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1797: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1798: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1799: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1800: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 1799: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

1795: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1796: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1797: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1798: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1799: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1800: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1801: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1802: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1803: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1918: FROM oe_hold_sources_all hs,

1914: AND oh.line_id IS NULL
1915: AND oh.hold_release_id IS NULL
1916: AND EXISTS
1917: (SELECT 1
1918: FROM oe_hold_sources_all hs,
1919: oe_hold_definitions h
1920: WHERE oh.hold_source_id = hs.hold_source_id
1921: AND hs.hold_id = h.hold_id
1922: AND NVL(h.item_type,

Line 2314: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

2310: , p_wf_item IN VARCHAR2 DEFAULT NULL
2311: , p_wf_activity IN VARCHAR2 DEFAULT NULL
2312: , p_hold_entity_code IN VARCHAR2 DEFAULT NULL
2313: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
2314: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
2315: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
2316: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
2317: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
2318: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 2317: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

2313: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
2314: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
2315: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
2316: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
2317: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
2318: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
2319: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2320: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2321: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2369: FROM oe_hold_sources_all hs,

2365: BEGIN
2366:
2367: SELECT 'ANY_HOLD_SOURCE'
2368: INTO l_dummy
2369: FROM oe_hold_sources_all hs,
2370: oe_hold_definitions h
2371: WHERE hs.hold_id = h.hold_id
2372: AND NVL(h.item_type,
2373: DECODE(p_chk_act_hold_only,

Line 2455: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC

2451: , p_entity_code IN VARCHAR2 DEFAULT NULL
2452: , p_entity_id IN NUMBER DEFAULT NULL
2453: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
2454: , p_entity_id2 IN NUMBER DEFAULT NULL
2455: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
2456: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
2457: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2458: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2459: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2470: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

2466: l_hold_release_id NUMBER;
2467: l_hold_source_id NUMBER := 0;
2468: l_order_hold_id NUMBER := 0;
2469: --ER#7479609 l_entity_code VARCHAR2(1);
2470: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2471:
2472: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2473: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2474: l_org_id number;

Line 2479: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

2475: l_check_authorization_flag varchar2(1):='N'; -- bug 8477694
2476: -- Define Cursors
2477: CURSOR hold_source IS
2478: SELECT HS.HOLD_SOURCE_ID,OH.ORDER_HOLD_ID
2479: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
2480: WHERE HS.HOLD_ID = p_hold_id
2481: AND HS.RELEASED_FLAG = 'N'
2482: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
2483: AND HS.HOLD_ENTITY_CODE = p_entity_code

Line 2544: FROM OE_HOLD_SOURCES

2540: -- Retrieving the entity code for this hold source
2541: -- Checking if its a valid hold source id
2542: SELECT hold_entity_code
2543: INTO l_entity_code
2544: FROM OE_HOLD_SOURCES
2545: WHERE hold_source_id = l_hold_source_id;
2546:
2547: EXCEPTION
2548: WHEN NO_DATA_FOUND THEN

Line 2696: -- order, deletes hold source records from OE_HOLD_SOURCES.

2692: -- Delete Holds
2693: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
2694: -- or for a line (p_line_id).
2695: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2696: -- order, deletes hold source records from OE_HOLD_SOURCES.
2697: -- If the hold or hold source was released and the same release record is
2698: -- not used by an existing hold or hold source, then deletes the
2699: -- release record also from OE_HOLD_RELEASES;
2700: ----------------------------------------------------------------------------

Line 2722: FROM OE_HOLD_SOURCES

2718: FROM OE_ORDER_HOLDS
2719: WHERE HEADER_ID = p_header_id;
2720: CURSOR hold_source IS
2721: SELECT hold_source_id, NVL(hold_release_id,0)
2722: FROM OE_HOLD_SOURCES
2723: WHERE HOLD_ENTITY_CODE = 'O'
2724: AND HOLD_ENTITY_ID = p_header_id;
2725: CURSOR line_hold IS
2726: SELECT order_hold_id, NVL(hold_release_id,0)

Line 2733: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL

2729:
2730: --ER#7479609 start
2731: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS
2732: SELECT OH.order_hold_id, NVL(OH.hold_release_id,0)
2733: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL
2734: WHERE OH.LINE_ID = p_top_model_line_id
2735: AND OH.LINE_ID = OL.LINE_ID
2736: AND OH.hold_source_id=HS.hold_source_id
2737: AND HS.hold_entity_id=OL.inventory_item_id

Line 2805: FROM OE_HOLD_SOURCES

2801: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
2802: FROM OE_ORDER_HOLDS
2803: UNION
2804: SELECT NVL(HOLD_RELEASE_ID,0)
2805: FROM OE_HOLD_SOURCES
2806: ); */
2807: END LOOP;
2808:
2809: CLOSE order_hold;

Line 2823: DELETE FROM OE_HOLD_SOURCES

2819:
2820: IF l_debug_level > 0 THEN
2821: oe_debug_pub.add( 'DELETING HOLD SOURCE RECORD' ) ;
2822: END IF;
2823: DELETE FROM OE_HOLD_SOURCES
2824: WHERE HOLD_SOURCE_ID = l_hold_source_id;
2825:
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;

Line 2862: FROM OE_HOLD_SOURCES

2858: (SELECT NVL(HOLD_RELEASE_ID,0)
2859: FROM OE_ORDER_HOLDS
2860: UNION
2861: SELECT NVL(HOLD_RELEASE_ID,0)
2862: FROM OE_HOLD_SOURCES
2863: ); */
2864: END LOOP;
2865:
2866: CLOSE line_hold;

Line 2961: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

2957: ( p_entity_code IN VARCHAR2
2958: , p_entity_id IN NUMBER
2959: , p_hold_entity_code IN VARCHAR2
2960: --ER#7479609 , p_hold_entity_id IN NUMBER
2961: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
2962: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2963: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2964: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2965: )

Line 2972: --l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC;

2968: l_order_hold_id NUMBER DEFAULT NULL;
2969: l_return_status VARCHAR2(30);
2970: l_msg_count NUMBER;
2971: l_msg_data VARCHAR2(2000);
2972: --l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC;
2973: temp NUMBER DEFAULT NULL;
2974: --l_attribute VARCHAR2(30); --ER#12571983
2975: l_attribute VARCHAR2(60); --ER#12571983
2976:

Line 2979: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

2975: l_attribute VARCHAR2(60); --ER#12571983
2976:
2977: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2978: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2979: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2980: --ER#7479609 l_hold_entity_id NUMBER;
2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2982: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2983: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

Line 2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

2977: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2978: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2979: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2980: --ER#7479609 l_hold_entity_id NUMBER;
2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2982: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2983: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2984: --ER#7479609 l_hold_entity_id2 NUMBER;
2985: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

Line 2983: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

2979: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2980: --ER#7479609 l_hold_entity_id NUMBER;
2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2982: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2983: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2984: --ER#7479609 l_hold_entity_id2 NUMBER;
2985: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
2986: l_hold_id NUMBER;
2987:

Line 2985: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2982: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2983: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2984: --ER#7479609 l_hold_entity_id2 NUMBER;
2985: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
2986: l_hold_id NUMBER;
2987:
2988: l_create_order_hold_flag VARCHAR2(1) := 'Y';
2989: --l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 3013: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

3009: --ER#7479609 CURSOR prev_hold IS
3010: CURSOR prev_hold(l_all_del_pay VARCHAR2) IS --ER#7479609
3011: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
3012: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code --ER#7479609
3013: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
3014: WHERE OH.HEADER_ID = l_header_id
3015: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
3016: NVL(l_line_id,FND_API.G_MISS_NUM)
3017: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 3028: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

3024: --ER#7479609 CURSOR prev_hold_entity2 IS
3025: CURSOR prev_hold_entity2(l_all_del_pay VARCHAR2) IS --ER#7479609
3026: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
3027: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code2 --ER#7479609
3028: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
3029: WHERE OH.HEADER_ID = l_header_id
3030: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
3031: NVL(l_line_id,FND_API.G_MISS_NUM)
3032: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 3044: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

3040: CURSOR curr_hold_source IS
3041: SELECT HS.hold_source_id, hs.hold_id,
3042: hs.hold_entity_code, hs.hold_entity_id,
3043: hs.hold_entity_code2,hs.hold_entity_id2
3044: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
3045: --WHERE HS.HOLD_ENTITY_CODE = p_hold_entity_code -- ER#3667551
3046: WHERE HS.HOLD_ENTITY_CODE = NVL(l_bth_entity_code,p_hold_entity_code) -- ER#3667551
3047: AND HS.HOLD_ID = NVL(l_bth_hold_id,HS.HOLD_ID) -- ER#3667551
3048: AND HS.HOLD_ENTITY_ID = p_hold_entity_id

Line 3061: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

3057: CURSOR curr_hold_source_entity2 IS
3058: SELECT HS.hold_source_id, hs.hold_id,
3059: hs.hold_entity_code, hs.hold_entity_id,
3060: hs.hold_entity_code2,hs.hold_entity_id2
3061: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
3062: --WHERE HS.HOLD_ENTITY_CODE2 = p_hold_entity_code -- ER#3667551
3063: WHERE HS.HOLD_ENTITY_CODE2 = NVL(l_bth_entity_code,p_hold_entity_code) -- ER#3667551
3064: AND HS.HOLD_ID = NVL(l_bth_hold_id,HS.HOLD_ID) -- ER#3667551
3065: AND HS.HOLD_ENTITY_ID2 = p_hold_entity_id

Line 3081: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,

3077: --
3078: --ER#7479609 start
3079: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
3080: l_line_rec OE_ORDER_LINES_ALL%rowtype;
3081: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
3082: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
3083:
3084: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
3085:

Line 3082: entity_id oe_hold_sources_all.hold_entity_id%TYPE);

3078: --ER#7479609 start
3079: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
3080: l_line_rec OE_ORDER_LINES_ALL%rowtype;
3081: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
3082: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
3083:
3084: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
3085:
3086: l_entity_tab entity_tab;

Line 4215: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

4211: ( p_entity_code IN VARCHAR2
4212: , p_entity_id IN NUMBER
4213: , p_hold_entity_code IN VARCHAR2
4214: --ER#7479609 , p_hold_entity_id IN NUMBER
4215: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
4216: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4217: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
4218: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4219: )

Line 4233: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

4229: l_attribute VARCHAR2(30);
4230: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4231: l_hold_entity_code VARCHAR2(1);
4232: --ER#7479609 l_hold_entity_id NUMBER;
4233: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4234: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
4235: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4236: --ER#7479609 l_hold_entity_id2 NUMBER;
4237: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

Line 4235: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

4231: l_hold_entity_code VARCHAR2(1);
4232: --ER#7479609 l_hold_entity_id NUMBER;
4233: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4234: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
4235: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4236: --ER#7479609 l_hold_entity_id2 NUMBER;
4237: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4238: l_hold_id NUMBER;
4239:

Line 4237: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

4233: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4234: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
4235: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4236: --ER#7479609 l_hold_entity_id2 NUMBER;
4237: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4238: l_hold_id NUMBER;
4239:
4240: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4241: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

Line 4241: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

4237: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4238: l_hold_id NUMBER;
4239:
4240: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4241: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4242: --ER#7479609 m_hold_entity_id NUMBER;
4243: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4244: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4245: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

Line 4243: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

4239:
4240: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4241: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4242: --ER#7479609 m_hold_entity_id NUMBER;
4243: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4244: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4245: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4246: --ER#7479609 m_hold_entity_id2 NUMBER;
4247: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

Line 4245: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

4241: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4242: --ER#7479609 m_hold_entity_id NUMBER;
4243: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4244: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4245: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4246: --ER#7479609 m_hold_entity_id2 NUMBER;
4247: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4248: m_counter NUMBER;
4249:

Line 4247: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

4243: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4244: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4245: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4246: --ER#7479609 m_hold_entity_id2 NUMBER;
4247: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4248: m_counter NUMBER;
4249:
4250:
4251: l_create_order_hold_flag VARCHAR2(1) := 'Y';

Line 4254: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609

4250:
4251: l_create_order_hold_flag VARCHAR2(1) := 'Y';
4252: --
4253: CURSOR curr_hold_source(p_hold_entity_code VARCHAR2,
4254: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609
4255: --ER#7479609 p_hold_entity_id NUMBER) IS
4256: SELECT HS.hold_source_id, hs.hold_id,
4257: hs.hold_entity_code, hs.hold_entity_id,
4258: hs.hold_entity_code2,hs.hold_entity_id2

Line 4259: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4255: --ER#7479609 p_hold_entity_id NUMBER) IS
4256: SELECT HS.hold_source_id, hs.hold_id,
4257: hs.hold_entity_code, hs.hold_entity_id,
4258: hs.hold_entity_code2,hs.hold_entity_id2
4259: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4260: WHERE HLD.HOLD_ID = HS.HOLD_ID
4261: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4262: ROUND( SYSDATE )
4263: AND HS.RELEASED_FLAG = 'N'

Line 4431: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

4427: l_attribute VARCHAR2(50);
4428: --
4429: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4430: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4431: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4432: --ER#7479609 l_hold_entity_id NUMBER;
4433: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4434: --ER#7479609
4435: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

Line 4433: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

4429: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4430: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4431: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4432: --ER#7479609 l_hold_entity_id NUMBER;
4433: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4434: --ER#7479609
4435: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4436:
4437: --ER#7479609 l_hold_entity_id2 NUMBER;

Line 4435: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

4431: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4432: --ER#7479609 l_hold_entity_id NUMBER;
4433: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4434: --ER#7479609
4435: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4436:
4437: --ER#7479609 l_hold_entity_id2 NUMBER;
4438: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4439: l_hold_id NUMBER;

Line 4438: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

4434: --ER#7479609
4435: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4436:
4437: --ER#7479609 l_hold_entity_id2 NUMBER;
4438: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4439: l_hold_id NUMBER;
4440: l_inventory_item_id NUMBER;
4441: l_sold_to_org_id NUMBER;
4442: l_invoice_to_org_id NUMBER;

Line 4447: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

4443: l_ship_to_org_id NUMBER;
4444: l_ship_from_org_id NUMBER;
4445:
4446: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4447: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4448: --ER#7479609 m_hold_entity_id NUMBER;
4449: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4450: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4451: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

Line 4449: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

4445:
4446: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4447: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4448: --ER#7479609 m_hold_entity_id NUMBER;
4449: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4450: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4451: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4452: --ER#7479609 m_hold_entity_id2 NUMBER;
4453: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

Line 4451: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

4447: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4448: --ER#7479609 m_hold_entity_id NUMBER;
4449: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4450: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4451: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4452: --ER#7479609 m_hold_entity_id2 NUMBER;
4453: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4454: m_counter NUMBER;
4455: l_blanket_number NUMBER;

Line 4453: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

4449: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4450: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4451: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4452: --ER#7479609 m_hold_entity_id2 NUMBER;
4453: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4454: m_counter NUMBER;
4455: l_blanket_number NUMBER;
4456: l_blanket_line_number NUMBER;
4457:

Line 4464: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609

4460: l_create_order_hold_flag VARCHAR2(1) := 'Y';
4461: --
4462: /*8602364 start
4463: CURSOR curr_hold_source(p_hold_entity_code VARCHAR2,
4464: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609
4465: --ER#7479609 p_hold_entity_id NUMBER) IS
4466: SELECT HS.hold_source_id, hs.hold_id,
4467: hs.hold_entity_code, hs.hold_entity_id,
4468: hs.hold_entity_code2,hs.hold_entity_id2

Line 4469: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4465: --ER#7479609 p_hold_entity_id NUMBER) IS
4466: SELECT HS.hold_source_id, hs.hold_id,
4467: hs.hold_entity_code, hs.hold_entity_id,
4468: hs.hold_entity_code2,hs.hold_entity_id2
4469: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4470: WHERE HLD.HOLD_ID = HS.HOLD_ID
4471: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4472: ROUND( SYSDATE )
4473: AND HS.RELEASED_FLAG = 'N'

Line 4489: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS

4485: ER#7479609 end*/
4486:
4487: --8602364 start
4488: CURSOR curr_hold_source(p_hold_entity_code VARCHAR2,
4489: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4490: SELECT HS.hold_source_id, hs.hold_id,
4491: hs.hold_entity_code, hs.hold_entity_id,
4492: hs.hold_entity_code2,hs.hold_entity_id2
4493: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

Line 4493: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4489: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4490: SELECT HS.hold_source_id, hs.hold_id,
4491: hs.hold_entity_code, hs.hold_entity_id,
4492: hs.hold_entity_code2,hs.hold_entity_id2
4493: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4494: WHERE HLD.HOLD_ID = HS.HOLD_ID
4495: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4496: ROUND( SYSDATE )
4497: AND HS.RELEASED_FLAG = 'N'

Line 4506: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS

4502: AND HS.HOLD_ENTITY_ID = p_hold_entity_id;
4503:
4504:
4505: CURSOR curr_hold_source_2(p_hold_entity_code VARCHAR2,
4506: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4507: SELECT HS.hold_source_id, hs.hold_id,
4508: hs.hold_entity_code, hs.hold_entity_id,
4509: hs.hold_entity_code2,hs.hold_entity_id2
4510: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

Line 4510: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4506: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4507: SELECT HS.hold_source_id, hs.hold_id,
4508: hs.hold_entity_code, hs.hold_entity_id,
4509: hs.hold_entity_code2,hs.hold_entity_id2
4510: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4511: WHERE HLD.HOLD_ID = HS.HOLD_ID
4512: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4513: ROUND( SYSDATE )
4514: AND HS.RELEASED_FLAG = 'N'

Line 4550: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4546: p_hold_entity_id2 NUMBER) IS
4547: SELECT HS.hold_source_id, hs.hold_id,
4548: hs.hold_entity_code, hs.hold_entity_id,
4549: hs.hold_entity_code2,hs.hold_entity_id2
4550: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4551: WHERE HLD.HOLD_ID = HS.HOLD_ID
4552: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4553: ROUND( SYSDATE )
4554: AND HS.RELEASED_FLAG = 'N'

Line 4565: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,

4561: */
4562: --ER#7479609 start
4563: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4564: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4565: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4566: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4567:
4568: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4569:

Line 4566: entity_id oe_hold_sources_all.hold_entity_id%TYPE);

4562: --ER#7479609 start
4563: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4564: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4565: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4566: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4567:
4568: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4569:
4570: l_entity_tab entity_tab;

Line 5518: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

5514:
5515: FUNCTION Hold_exists
5516: ( p_hold_entity_code IN VARCHAR2
5517: --ER#7479609 , p_hold_entity_id IN NUMBER
5518: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5519: , p_hold_id IN NUMBER DEFAULT 1
5520: , p_org_id IN NUMBER DEFAULT NULL
5521: ) RETURN boolean IS
5522:

Line 5535: FROM OE_HOLD_SOURCES_ALL

5531: IF p_org_id IS NULL THEN
5532:
5533: SELECT 'Y'
5534: INTO l_hold_exists
5535: FROM OE_HOLD_SOURCES_ALL
5536: WHERE hold_entity_code = p_hold_entity_code
5537: AND HOLD_ENTITY_ID = p_hold_entity_id
5538: AND hold_id = p_hold_id
5539: AND nvl(RELEASED_FLAG, 'N') = 'N'

Line 5545: FROM OE_HOLD_SOURCES_ALL

5541: ELSE
5542:
5543: SELECT 'Y'
5544: INTO l_hold_exists
5545: FROM OE_HOLD_SOURCES_ALL
5546: WHERE hold_entity_code = p_hold_entity_code
5547: AND HOLD_ENTITY_ID = p_hold_entity_id
5548: AND hold_id = p_hold_id
5549: AND nvl(RELEASED_FLAG, 'N') = 'N'

Line 5585: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

5581: */
5582: PROCEDURE Process_Holds_Customer
5583: ( p_hold_entity_code IN VARCHAR2
5584: --ER#7479609 , p_hold_entity_id IN NUMBER
5585: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5586: , p_hold_id IN NUMBER DEFAULT 1
5587: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5588: , p_action IN VARCHAR2
5589: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 5607: FROM OE_HOLD_SOURCES_ALL src

5603: SELECT DISTINCT org_id
5604: FROM HZ_CUST_ACCT_SITES_ALL acct
5605: WHERE acct.cust_account_id = p_hold_entity_id
5606: AND NOT EXISTS (SELECT 1
5607: FROM OE_HOLD_SOURCES_ALL src
5608: WHERE acct.cust_account_id = src.hold_entity_id
5609: AND src.hold_entity_code = 'C'
5610: AND acct.org_id = src.org_id
5611: AND src.hold_id = p_hold_id

Line 5619: from oe_hold_sources_all

5615: SELECT DISTINCT org_id
5616: FROM OE_ORDER_HEADERS_ALL hdr
5617: WHERE sold_to_org_id = p_hold_entity_id
5618: AND NOT EXISTS (select 1
5619: from oe_hold_sources_all
5620: where hold_entity_id = p_hold_entity_id
5621: and hold_entity_code = 'C'
5622: and hold_id = p_hold_id
5623: and nvl(RELEASED_FLAG, 'N') = 'N')

Line 5632: FROM OE_HOLD_SOURCES_ALL

5628:
5629:
5630: CURSOR c_cust_holds IS
5631: SELECT org_id, hold_source_id
5632: FROM OE_HOLD_SOURCES_ALL
5633: WHERE hold_entity_id = p_hold_entity_id
5634: AND hold_entity_code = 'C'
5635: AND nvl(released_flag,'N') = 'N';
5636:

Line 5752: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

5748: */
5749: PROCEDURE Process_Holds_Site
5750: ( p_hold_entity_code IN VARCHAR2
5751: --ER#7479609 , p_hold_entity_id IN NUMBER
5752: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5753: , p_hold_id IN NUMBER DEFAULT 1
5754: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5755: , p_action IN VARCHAR2
5756: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 5904: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

5900: ( p_api_version IN NUMBER
5901: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
5902: , p_hold_entity_code IN VARCHAR2
5903: --ER#7479609 , p_hold_entity_id IN NUMBER
5904: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5905: , p_hold_id IN NUMBER DEFAULT 1
5906: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5907: , p_action IN VARCHAR2
5908: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2