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_ALL

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 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 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 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 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 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 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 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 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 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 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 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