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 345: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

341: (p_header_id IN NUMBER DEFAULT NULL
342: , p_line_id IN NUMBER DEFAULT NULL
343: , p_hold_entity_code IN VARCHAR2
344: --ER#7479609 , p_hold_entity_id IN NUMBER
345: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
346: , p_hold_entity_code2 IN VARCHAR2
347: --ER#7479609 , p_hold_entity_id2 IN NUMBER
348: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE --ER#7479609
349: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

344: --ER#7479609 , p_hold_entity_id IN NUMBER
345: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
346: , p_hold_entity_code2 IN VARCHAR2
347: --ER#7479609 , p_hold_entity_id2 IN NUMBER
348: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE --ER#7479609
349: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
350: )
351: IS
352: l_api_name CONSTANT VARCHAR2(30) := 'ValidateOrder';

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

924: l_hold_source_id NUMBER := 0;
925: l_dummy VARCHAR2(30);
926: l_order_holds_s NUMBER := 0;
927: --ER#7479609 l_entity_code VARCHAR2(1);
928: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
929: l_entity_id NUMBER;
930: --
931: --ER#7479609 l_entity_code2 VARCHAR2(1);
932: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

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

928: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
929: l_entity_id NUMBER;
930: --
931: --ER#7479609 l_entity_code2 VARCHAR2(1);
932: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
933: l_entity_id2 NUMBER;
934: l_header_id NUMBER DEFAULT NULL;
935:
936: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

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

1197: , p_wf_item IN VARCHAR2 DEFAULT NULL
1198: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1199: , p_entity_code IN VARCHAR2 DEFAULT NULL
1200: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1201: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1202: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1203: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1204: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1205: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

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

1200: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1201: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1202: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1203: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1204: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1205: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1206: , p_ii_parent_flag IN VARCHAR2 DEFAULT 'N'
1207: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1208: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1251: FROM oe_hold_sources_all hs,

1247: and oh.line_id = p_line_id
1248: and oh.hold_release_id is null
1249: AND EXISTS
1250: (SELECT 1
1251: FROM oe_hold_sources_all hs,
1252: oe_hold_definitions h
1253: WHERE oh.hold_source_id = hs.hold_source_id
1254: AND hs.hold_id = h.hold_id
1255: AND NVL(h.item_type,

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

1335: , p_wf_item IN VARCHAR2 DEFAULT NULL
1336: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1337: , p_entity_code IN VARCHAR2 DEFAULT NULL
1338: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1339: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1340: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1341: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1342: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1343: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

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

1338: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1339: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1340: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1341: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1342: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1343: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1344: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1345: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1346: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1381: FROM oe_hold_sources_all hs,

1377: and ol.top_model_line_id = p_top_model_line_id)
1378: and oh.hold_release_id is null
1379: AND EXISTS
1380: (SELECT 1
1381: FROM oe_hold_sources_all hs,
1382: oe_hold_definitions h
1383: WHERE oh.hold_source_id = hs.hold_source_id
1384: AND hs.hold_id = h.hold_id
1385: AND NVL(h.item_type,

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

1462: , p_wf_item IN VARCHAR2 DEFAULT NULL
1463: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1464: , p_entity_code IN VARCHAR2 DEFAULT NULL
1465: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1466: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1467: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1468: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1469: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1470: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

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

1465: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1466: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1467: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1468: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1469: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1470: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1471: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1472: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1473: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1507: FROM oe_hold_sources_all hs,

1503: and ol.top_model_line_id = p_top_model_line_id)
1504: and oh.hold_release_id is null
1505: AND EXISTS
1506: (SELECT 1
1507: FROM oe_hold_sources_all hs,
1508: oe_hold_definitions h
1509: WHERE oh.hold_source_id = hs.hold_source_id
1510: AND hs.hold_id = h.hold_id
1511: AND NVL(h.item_type,

Line 1615: FROM oe_hold_sources_all hs,

1611: and OH.HOLD_RELEASE_ID IS NULL
1612: and ROWNUM = 1
1613: AND EXISTS
1614: (SELECT 1
1615: FROM oe_hold_sources_all hs,
1616: oe_hold_definitions h
1617: WHERE oh.hold_source_id = hs.hold_source_id
1618: AND hs.hold_id = h.hold_id
1619: AND NVL(h.item_type,

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

1703: , p_wf_item IN VARCHAR2 DEFAULT NULL
1704: , p_wf_activity IN VARCHAR2 DEFAULT NULL
1705: , p_entity_code IN VARCHAR2 DEFAULT NULL
1706: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1707: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1708: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1709: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1710: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1711: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

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

1706: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
1707: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
1708: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
1709: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
1710: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
1711: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
1712: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1713: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1714: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1829: FROM oe_hold_sources_all hs,

1825: AND oh.line_id IS NULL
1826: AND oh.hold_release_id IS NULL
1827: AND EXISTS
1828: (SELECT 1
1829: FROM oe_hold_sources_all hs,
1830: oe_hold_definitions h
1831: WHERE oh.hold_source_id = hs.hold_source_id
1832: AND hs.hold_id = h.hold_id
1833: AND NVL(h.item_type,

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

2221: , p_wf_item IN VARCHAR2 DEFAULT NULL
2222: , p_wf_activity IN VARCHAR2 DEFAULT NULL
2223: , p_hold_entity_code IN VARCHAR2 DEFAULT NULL
2224: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
2225: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
2226: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
2227: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
2228: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
2229: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

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

2224: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
2225: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
2226: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
2227: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
2228: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
2229: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
2230: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2231: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2232: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2280: FROM oe_hold_sources_all hs,

2276: BEGIN
2277:
2278: SELECT 'ANY_HOLD_SOURCE'
2279: INTO l_dummy
2280: FROM oe_hold_sources_all hs,
2281: oe_hold_definitions h
2282: WHERE hs.hold_id = h.hold_id
2283: AND NVL(h.item_type,
2284: DECODE(p_chk_act_hold_only,

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

2376: l_hold_release_id NUMBER;
2377: l_hold_source_id NUMBER := 0;
2378: l_order_hold_id NUMBER := 0;
2379: --ER#7479609 l_entity_code VARCHAR2(1);
2380: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2381:
2382: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2383: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2384: l_org_id number;

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

2865: ( p_entity_code IN VARCHAR2
2866: , p_entity_id IN NUMBER
2867: , p_hold_entity_code IN VARCHAR2
2868: --ER#7479609 , p_hold_entity_id IN NUMBER
2869: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
2870: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2871: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2872: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2873: )

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

2882: l_attribute VARCHAR2(30);
2883:
2884: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2885: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2886: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2887: --ER#7479609 l_hold_entity_id NUMBER;
2888: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2889: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2890: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

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

2884: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2885: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2886: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2887: --ER#7479609 l_hold_entity_id NUMBER;
2888: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2889: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2890: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2891: --ER#7479609 l_hold_entity_id2 NUMBER;
2892: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

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

2886: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2887: --ER#7479609 l_hold_entity_id NUMBER;
2888: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2889: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2890: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2891: --ER#7479609 l_hold_entity_id2 NUMBER;
2892: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
2893: l_hold_id NUMBER;
2894:

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

2888: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
2889: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
2890: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
2891: --ER#7479609 l_hold_entity_id2 NUMBER;
2892: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
2893: l_hold_id NUMBER;
2894:
2895: l_create_order_hold_flag VARCHAR2(1) := 'Y';
2896: --l_line_rec OE_Order_PUB.Line_Rec_Type;

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

2971: --
2972: --ER#7479609 start
2973: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
2974: l_line_rec OE_ORDER_LINES_ALL%rowtype;
2975: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
2976: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
2977:
2978: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
2979:

Line 2976: entity_id oe_hold_sources_all.hold_entity_id%TYPE);

2972: --ER#7479609 start
2973: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
2974: l_line_rec OE_ORDER_LINES_ALL%rowtype;
2975: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
2976: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
2977:
2978: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
2979:
2980: l_entity_tab entity_tab;

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

3953: ( p_entity_code IN VARCHAR2
3954: , p_entity_id IN NUMBER
3955: , p_hold_entity_code IN VARCHAR2
3956: --ER#7479609 , p_hold_entity_id IN NUMBER
3957: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
3958: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3959: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3960: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3961: )

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

3971: l_attribute VARCHAR2(30);
3972: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3973: l_hold_entity_code VARCHAR2(1);
3974: --ER#7479609 l_hold_entity_id NUMBER;
3975: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3976: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
3977: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3978: --ER#7479609 l_hold_entity_id2 NUMBER;
3979: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

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

3973: l_hold_entity_code VARCHAR2(1);
3974: --ER#7479609 l_hold_entity_id NUMBER;
3975: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3976: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
3977: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3978: --ER#7479609 l_hold_entity_id2 NUMBER;
3979: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
3980: l_hold_id NUMBER;
3981:

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

3975: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3976: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);
3977: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3978: --ER#7479609 l_hold_entity_id2 NUMBER;
3979: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
3980: l_hold_id NUMBER;
3981:
3982: --ER#7479609 m_hold_entity_code VARCHAR2(1);
3983: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

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

3979: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
3980: l_hold_id NUMBER;
3981:
3982: --ER#7479609 m_hold_entity_code VARCHAR2(1);
3983: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3984: --ER#7479609 m_hold_entity_id NUMBER;
3985: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3986: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
3987: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

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

3981:
3982: --ER#7479609 m_hold_entity_code VARCHAR2(1);
3983: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3984: --ER#7479609 m_hold_entity_id NUMBER;
3985: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3986: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
3987: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
3988: --ER#7479609 m_hold_entity_id2 NUMBER;
3989: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

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

3983: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
3984: --ER#7479609 m_hold_entity_id NUMBER;
3985: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3986: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
3987: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
3988: --ER#7479609 m_hold_entity_id2 NUMBER;
3989: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
3990: m_counter NUMBER;
3991:

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

3985: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3986: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
3987: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
3988: --ER#7479609 m_hold_entity_id2 NUMBER;
3989: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
3990: m_counter NUMBER;
3991:
3992:
3993: l_create_order_hold_flag VARCHAR2(1) := 'Y';

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

3992:
3993: l_create_order_hold_flag VARCHAR2(1) := 'Y';
3994: --
3995: CURSOR curr_hold_source(p_hold_entity_code VARCHAR2,
3996: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609
3997: --ER#7479609 p_hold_entity_id NUMBER) IS
3998: SELECT HS.hold_source_id, hs.hold_id,
3999: hs.hold_entity_code, hs.hold_entity_id,
4000: hs.hold_entity_code2,hs.hold_entity_id2

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

4169: l_attribute VARCHAR2(50);
4170: --
4171: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4172: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4173: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4174: --ER#7479609 l_hold_entity_id NUMBER;
4175: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4176: --ER#7479609
4177: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609

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

4171: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4172: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4173: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4174: --ER#7479609 l_hold_entity_id NUMBER;
4175: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4176: --ER#7479609
4177: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4178:
4179: --ER#7479609 l_hold_entity_id2 NUMBER;

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

4173: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4174: --ER#7479609 l_hold_entity_id NUMBER;
4175: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4176: --ER#7479609
4177: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4178:
4179: --ER#7479609 l_hold_entity_id2 NUMBER;
4180: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4181: l_hold_id NUMBER;

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

4176: --ER#7479609
4177: l_hold_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
4178:
4179: --ER#7479609 l_hold_entity_id2 NUMBER;
4180: l_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4181: l_hold_id NUMBER;
4182: l_inventory_item_id NUMBER;
4183: l_sold_to_org_id NUMBER;
4184: l_invoice_to_org_id NUMBER;

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

4185: l_ship_to_org_id NUMBER;
4186: l_ship_from_org_id NUMBER;
4187:
4188: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4189: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4190: --ER#7479609 m_hold_entity_id NUMBER;
4191: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4192: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4193: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609

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

4187:
4188: --ER#7479609 m_hold_entity_code VARCHAR2(1);
4189: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4190: --ER#7479609 m_hold_entity_id NUMBER;
4191: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4192: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4193: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4194: --ER#7479609 m_hold_entity_id2 NUMBER;
4195: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609

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

4189: m_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4190: --ER#7479609 m_hold_entity_id NUMBER;
4191: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4192: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4193: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4194: --ER#7479609 m_hold_entity_id2 NUMBER;
4195: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4196: m_counter NUMBER;
4197: l_blanket_number NUMBER;

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

4191: m_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4192: --ER#7479609 m_hold_entity_code2 VARCHAR2(1);
4193: m_hold_entity_code2 oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4194: --ER#7479609 m_hold_entity_id2 NUMBER;
4195: m_hold_entity_id2 oe_hold_sources_all.hold_entity_id2%TYPE; --ER#7479609
4196: m_counter NUMBER;
4197: l_blanket_number NUMBER;
4198: l_blanket_line_number NUMBER;
4199:

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

4201:
4202: l_create_order_hold_flag VARCHAR2(1) := 'Y';
4203: --
4204: CURSOR curr_hold_source(p_hold_entity_code VARCHAR2,
4205: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS --ER#7479609
4206: --ER#7479609 p_hold_entity_id NUMBER) IS
4207: SELECT HS.hold_source_id, hs.hold_id,
4208: hs.hold_entity_code, hs.hold_entity_id,
4209: hs.hold_entity_code2,hs.hold_entity_id2

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

4264: */
4265: --ER#7479609 start
4266: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4267: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4268: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4269: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4270:
4271: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4272:

Line 4269: entity_id oe_hold_sources_all.hold_entity_id%TYPE);

4265: --ER#7479609 start
4266: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4267: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4268: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4269: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4270:
4271: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4272:
4273: l_entity_tab entity_tab;

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

4967:
4968: FUNCTION Hold_exists
4969: ( p_hold_entity_code IN VARCHAR2
4970: --ER#7479609 , p_hold_entity_id IN NUMBER
4971: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
4972: , p_hold_id IN NUMBER DEFAULT 1
4973: , p_org_id IN NUMBER DEFAULT NULL
4974: ) RETURN boolean IS
4975:

Line 4988: FROM OE_HOLD_SOURCES_ALL

4984: IF p_org_id IS NULL THEN
4985:
4986: SELECT 'Y'
4987: INTO l_hold_exists
4988: FROM OE_HOLD_SOURCES_ALL
4989: WHERE hold_entity_code = p_hold_entity_code
4990: AND HOLD_ENTITY_ID = p_hold_entity_id
4991: AND hold_id = p_hold_id
4992: AND nvl(RELEASED_FLAG, 'N') = 'N'

Line 4998: FROM OE_HOLD_SOURCES_ALL

4994: ELSE
4995:
4996: SELECT 'Y'
4997: INTO l_hold_exists
4998: FROM OE_HOLD_SOURCES_ALL
4999: WHERE hold_entity_code = p_hold_entity_code
5000: AND HOLD_ENTITY_ID = p_hold_entity_id
5001: AND hold_id = p_hold_id
5002: AND nvl(RELEASED_FLAG, 'N') = 'N'

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

5034: */
5035: PROCEDURE Process_Holds_Customer
5036: ( p_hold_entity_code IN VARCHAR2
5037: --ER#7479609 , p_hold_entity_id IN NUMBER
5038: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5039: , p_hold_id IN NUMBER DEFAULT 1
5040: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5041: , p_action IN VARCHAR2
5042: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 5060: FROM OE_HOLD_SOURCES_ALL src

5056: SELECT DISTINCT org_id
5057: FROM HZ_CUST_ACCT_SITES_ALL acct
5058: WHERE acct.cust_account_id = p_hold_entity_id
5059: AND NOT EXISTS (SELECT 1
5060: FROM OE_HOLD_SOURCES_ALL src
5061: WHERE acct.cust_account_id = src.hold_entity_id
5062: AND src.hold_entity_code = 'C'
5063: AND acct.org_id = src.org_id
5064: AND src.hold_id = p_hold_id

Line 5072: from oe_hold_sources_all

5068: SELECT DISTINCT org_id
5069: FROM OE_ORDER_HEADERS_ALL hdr
5070: WHERE sold_to_org_id = p_hold_entity_id
5071: AND NOT EXISTS (select 1
5072: from oe_hold_sources_all
5073: where hold_entity_id = p_hold_entity_id
5074: and hold_entity_code = 'C'
5075: and hold_id = p_hold_id
5076: and nvl(RELEASED_FLAG, 'N') = 'N')

Line 5085: FROM OE_HOLD_SOURCES_ALL

5081:
5082:
5083: CURSOR c_cust_holds IS
5084: SELECT org_id, hold_source_id
5085: FROM OE_HOLD_SOURCES_ALL
5086: WHERE hold_entity_id = p_hold_entity_id
5087: AND hold_entity_code = 'C'
5088: AND nvl(released_flag,'N') = 'N';
5089:

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

5201: */
5202: PROCEDURE Process_Holds_Site
5203: ( p_hold_entity_code IN VARCHAR2
5204: --ER#7479609 , p_hold_entity_id IN NUMBER
5205: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5206: , p_hold_id IN NUMBER DEFAULT 1
5207: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5208: , p_action IN VARCHAR2
5209: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

5353: ( p_api_version IN NUMBER
5354: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
5355: , p_hold_entity_code IN VARCHAR2
5356: --ER#7479609 , p_hold_entity_id IN NUMBER
5357: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
5358: , p_hold_id IN NUMBER DEFAULT 1
5359: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
5360: , p_action IN VARCHAR2
5361: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2