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_PVT dependencies on OE_HOLD_DEFINITIONS

Line 301: l_hold_name oe_hold_definitions.name%type := '';

297: function hold_name(
298: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)
299: return varchar2
300: IS
301: l_hold_name oe_hold_definitions.name%type := '';
302: BEGIN
303: select hd.name
304: into l_hold_name
305: from oe_hold_sources hs,

Line 306: oe_hold_definitions hd

302: BEGIN
303: select hd.name
304: into l_hold_name
305: from oe_hold_sources hs,
306: oe_hold_definitions hd
307: where hs.HOLD_SOURCE_ID = p_hold_source_id
308: and hs.hold_id = hd.hold_id;
309:
310: return l_hold_name;

Line 414: oe_hold_definitions hd

410: SELECT 'Y'
411: INTO l_release_children
412: FROM oe_order_holds oh,
413: oe_hold_sources hs,
414: oe_hold_definitions hd
415: WHERE hs.hold_source_id = oh.hold_source_id
416: AND hs.hold_id = hd.hold_id
417: AND hd.hold_id = p_hold_id
418: AND oh.header_id = p_order_tbl(1).header_id

Line 687: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

683: -------------------------------------
684: -- CHECK_AUTHORIZATION
685: -------------------------------------
686: function check_authorization (
687: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
688: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
689: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
690: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
691: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1565: oe_hold_definitions ohd,

1561: FROM DUAL
1562: WHERE EXISTS (SELECT NULL
1563: FROM oe_order_holds ooh,
1564: oe_hold_sources ohs,
1565: oe_hold_definitions ohd,
1566: oe_order_headers_all h,
1567: oe_order_sources oos
1568: WHERE ooh.header_id = h.header_id
1569: -- AND ohd.activity_name IS NULL Bug 6791587

Line 1584: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;

1580: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1581: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1582: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;
1583: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
1584: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;
1585:
1586: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
1587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1588: BEGIN

Line 1751: from oe_hold_definitions

1747: is
1748: select
1749: item_type
1750: , nvl(apply_to_order_and_line_flag, 'N')
1751: from oe_hold_definitions
1752: where hold_id = l_hold_id;
1753:
1754: BEGIN
1755: OE_Debug_PUB.Add('In OE_holds_PUB.Validate_Hold_source',1);

Line 2256: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_id%TYPE,

2252:
2253:
2254: -----------------------
2255: Procedure Validate_Hold (
2256: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_id%TYPE,
2257: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2258: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2259: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2260: IS

Line 2279: FROM OE_HOLD_DEFINITIONS

2275:
2276: BEGIN
2277: SELECT 'x'
2278: INTO l_dummy
2279: FROM OE_HOLD_DEFINITIONS
2280: WHERE HOLD_ID = p_hold_id
2281: AND SYSDATE
2282: BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
2283: AND NVL(END_DATE_ACTIVE, SYSDATE );

Line 2832: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

2828: l_api_name CONSTANT VARCHAR2(30) := 'Create_Order_Holds';
2829: l_site_use_code VARCHAR2(30);
2830: /*Added the three variables for WF_HOLDS bug 6449458*/
2831: l_is_hold_applied BOOLEAN DEFAULT NULL;
2832: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
2833: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
2834:
2835:
2836: /* Moved to Overloaded Procedure under Bug 6801108

Line 2833: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

2829: l_site_use_code VARCHAR2(30);
2830: /*Added the three variables for WF_HOLDS bug 6449458*/
2831: l_is_hold_applied BOOLEAN DEFAULT NULL;
2832: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
2833: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
2834:
2835:
2836: /* Moved to Overloaded Procedure under Bug 6801108
2837: -- GENESIS --

Line 2846: oe_hold_definitions ohd,

2842: FROM DUAL
2843: WHERE EXISTS (SELECT NULL
2844: FROM oe_order_holds ooh,
2845: oe_hold_sources ohs,
2846: oe_hold_definitions ohd,
2847: oe_order_headers_all h,
2848: oe_order_sources oos
2849: WHERE ohd.activity_name IS NULL
2850: AND ohd.hold_id = ohs.hold_id

Line 2863: oe_hold_definitions ohd,

2859: FROM DUAL
2860: WHERE EXISTS (SELECT NULL
2861: FROM oe_order_holds ooh,
2862: oe_hold_sources ohs,
2863: oe_hold_definitions ohd,
2864: oe_order_headers_all h,
2865: oe_order_sources oos
2866: WHERE ohd.activity_name IS NULL
2867: AND ohd.hold_id = ohs.hold_id

Line 2879: oe_hold_definitions ohd

2875: SELECT 'Y'
2876: FROM DUAL
2877: WHERE EXISTS (SELECT NULL
2878: FROM oe_hold_sources ohs,
2879: oe_hold_definitions ohd
2880: WHERE ohd.activity_name IS NULL
2881: AND ohd.hold_id = ohs.hold_id
2882: AND ohs.hold_source_id = p_hld_src_id);
2883:

Line 2904: from oe_hold_definitions

2900:
2901: Begin
2902: select item_type, activity_name
2903: into l_wf_item_type, l_wf_activity_name
2904: from oe_hold_definitions
2905: where hold_id = p_hold_source_rec.hold_id;
2906: Exception
2907: When NO_DATA_FOUND Then
2908: NULL; -- OE_Holds_Pvt.Validate has not yet been called.

Line 4790: oe_hold_definitions ohd

4786: SELECT 'Y'
4787: FROM DUAL
4788: WHERE EXISTS (SELECT NULL
4789: FROM oe_hold_sources ohs,
4790: oe_hold_definitions ohd
4791: WHERE ohd.hold_id = ohs.hold_id
4792: -- AND ohd.activity_name IS NULL Bug 6791587
4793: AND ohs.hold_source_id = p_hld_src_id
4794: AND ohs.hold_entity_code <> 'O');

Line 5398: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

5394:
5395: --------------------
5396: Procedure Apply_Holds (
5397: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
5398: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
5399: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE,
5400: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE,
5401: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5402: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 5412: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

5408: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5409: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5410: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5411: /*Added the Following Variables for WF_HOLDS ER (bug 6449458)*/
5412: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5413: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5414: l_is_hold_applied BOOLEAN;
5415: l_count_of_holds_applied NUMBER := 0;
5416: l_user_activity_name VARCHAR2(80);

Line 5413: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

5409: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5410: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5411: /*Added the Following Variables for WF_HOLDS ER (bug 6449458)*/
5412: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5413: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5414: l_is_hold_applied BOOLEAN;
5415: l_count_of_holds_applied NUMBER := 0;
5416: l_user_activity_name VARCHAR2(80);
5417:

Line 5510: from oe_hold_definitions

5506: for WF_HOLDS ER (bug 6449458)*/
5507: IF l_wf_item_type IS NULL AND l_wf_activity_name IS NULL THEN
5508: select item_type, activity_name
5509: into l_wf_item_type, l_wf_activity_name
5510: from oe_hold_definitions
5511: where hold_id = l_hold_source_rec.hold_id;
5512: END IF;
5513:
5514: IF l_wf_item_type IS NOT NULL AND l_wf_activity_name IS NOT

Line 5611: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

5607: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5608: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5609: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/
5610: l_hold_msg_applied BOOLEAN DEFAULT NULL;
5611: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5612: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5613:
5614: BEGIN
5615:

Line 5612: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

5608: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5609: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/
5610: l_hold_msg_applied BOOLEAN DEFAULT NULL;
5611: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5612: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5613:
5614: BEGIN
5615:
5616:

Line 5620: from oe_hold_definitions

5616:
5617: Begin
5618: select item_type, activity_name
5619: into l_wf_item_type, l_wf_activity_name
5620: from oe_hold_definitions
5621: where hold_id = p_hold_source_rec.hold_id;
5622: Exception
5623: When NO_DATA_FOUND Then
5624: NULL; -- OE_Holds_Pvt.Validate has not yet been called.

Line 5780: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

5776:
5777: ---------------------
5778: Procedure Release_Holds (
5779: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
5780: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
5781: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
5782: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE,
5783: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5784: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 5931: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

5927:
5928: procedure process_apply_holds_lines (
5929: p_num_of_records IN NUMBER
5930: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
5931: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
5932: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
5933: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
5934: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5935: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 5958: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

5954: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5955: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5956: l_msg_token VARCHAR2(100);
5957: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
5958: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5959: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5960: l_is_hold_applied BOOLEAN;
5961: l_count_of_holds_applied NUMBER := 0;
5962: l_user_activity_name VARCHAR2(80);

Line 5959: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

5955: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5956: l_msg_token VARCHAR2(100);
5957: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
5958: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5959: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5960: l_is_hold_applied BOOLEAN;
5961: l_count_of_holds_applied NUMBER := 0;
5962: l_user_activity_name VARCHAR2(80);
5963:

Line 6047: from oe_hold_definitions

6043: /*Added the IF condition for WF_HOLDS ER (bug 6449458)*/
6044: IF l_item_type IS NULL AND l_activity_name IS NULL THEN
6045: select item_type, activity_name
6046: into l_item_type, l_activity_name
6047: from oe_hold_definitions
6048: where hold_id = l_hold_source_rec.hold_id;
6049: END IF;
6050:
6051: OE_DEBUG_PUB.Add('Before calling oe_holds_pvt.apply_holds');

Line 6184: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

6180: /*=================================*/
6181: procedure process_apply_holds_orders (
6182: p_num_of_records IN NUMBER
6183: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6184: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6185: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6186: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6187: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6188: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 6208: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

6204: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6205: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6206: l_msg_token VARCHAR2(100);
6207: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6208: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6209: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6210: l_is_hold_applied BOOLEAN;
6211: l_count_of_holds_applied NUMBER := 0;
6212: l_user_activity_name VARCHAR2(80);

Line 6209: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

6205: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6206: l_msg_token VARCHAR2(100);
6207: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6208: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6209: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6210: l_is_hold_applied BOOLEAN;
6211: l_count_of_holds_applied NUMBER := 0;
6212: l_user_activity_name VARCHAR2(80);
6213:

Line 6290: from oe_hold_definitions

6286: /*Added the IF condition for WF_HOLDS ER (bug 6449458)*/
6287: IF l_item_type IS NULL AND l_activity_name IS NULL THEN
6288: select item_type, activity_name
6289: into l_item_type, l_activity_name
6290: from oe_hold_definitions
6291: where hold_id = l_hold_source_rec.hold_id;
6292: END IF;
6293:
6294: OE_DEBUG_PUB.Add('Before calling oe_holds_pvt.apply_holds');

Line 6424: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

6420:
6421: procedure process_release_holds_lines (
6422: p_num_of_records IN NUMBER
6423: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6424: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6425: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
6426: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
6427: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6428: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 6600: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

6596: */
6597: procedure process_release_holds_orders (
6598: p_num_of_records IN NUMBER
6599: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6600: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6601: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
6602: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
6603: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6604: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 6789: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

6785: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6786: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6787: l_msg_token VARCHAR2(100);
6788: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6789: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6790: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6791: l_is_hold_applied BOOLEAN;
6792: l_count_of_holds_applied NUMBER := 0;
6793:

Line 6790: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;

6786: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6787: l_msg_token VARCHAR2(100);
6788: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6789: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6790: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6791: l_is_hold_applied BOOLEAN;
6792: l_count_of_holds_applied NUMBER := 0;
6793:
6794: --

Line 6849: from oe_hold_definitions

6845: oe_debug_pub.add('p_hold_future_flg->' || p_hold_future_flg,3);
6846: /*added the select statement for WF_HOLDS ER (bug 6449458)*/
6847: select item_type, activity_name
6848: into l_item_type, l_activity_name
6849: from oe_hold_definitions
6850: where hold_id = l_hold_source_rec.hold_id;
6851:
6852: if (p_hold_existing_flg = 'Y' AND p_hold_future_flg = 'Y') then
6853: oe_debug_pub.add('Calling oe_holds_pvt.apply_Holds',3);

Line 7009: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;

7005: IS
7006: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7007: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7008: l_api_name CONSTANT VARCHAR2(30) := 'process_release_source';
7009: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
7010: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7011: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7012: --ER#7479609 l_hold_entity_code varchar2(1); /* Added for Bug 1946783 */
7013: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

Line 7180: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

7176:
7177: procedure process_release_holds_lines (
7178: p_num_of_records IN NUMBER
7179: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7180: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7181: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7182: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7183: , p_wf_release_action IN VARCHAR2
7184: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7389: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

7385:
7386: procedure process_release_holds_orders (
7387: p_num_of_records IN NUMBER
7388: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7389: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7390: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7391: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7392: , p_wf_release_action IN VARCHAR2
7393: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7599: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;

7595: IS
7596: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7597: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7598: l_api_name CONSTANT VARCHAR2(30) := 'process_release_source';
7599: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
7600: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7601: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7602: --ER#7479609 l_hold_entity_code VARCHAR2(1); /* Added for Bug 1946783 */
7603: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

Line 8068: oe_hold_definitions ohd,

8064: FROM DUAL
8065: WHERE EXISTS (SELECT NULL
8066: FROM oe_order_holds ooh,
8067: oe_hold_sources ohs,
8068: oe_hold_definitions ohd,
8069: oe_order_headers_all h,
8070: oe_order_sources oos
8071: WHERE ohd.hold_id = ohs.hold_id
8072: -- AND ohd.activity_name IS NULL Bug 6791587

Line 8085: oe_hold_definitions ohd,

8081: FROM DUAL
8082: WHERE EXISTS (SELECT NULL
8083: FROM oe_order_holds ooh,
8084: oe_hold_sources ohs,
8085: oe_hold_definitions ohd,
8086: oe_order_headers_all h,
8087: oe_order_sources oos
8088: WHERE ohd.hold_id = ohs.hold_id
8089: -- AND ohd.activity_name IS NULL Bug 6791587

Line 8101: oe_hold_definitions ohd

8097: SELECT 'Y'
8098: FROM DUAL
8099: WHERE EXISTS (SELECT NULL
8100: FROM oe_hold_sources ohs,
8101: oe_hold_definitions ohd
8102: WHERE ohd.hold_id = ohs.hold_id
8103: --AND ohd.activity_name IS NULL Bug 6791587
8104: AND ohs.hold_source_id = p_hld_src_id);
8105: ER#7479609*/

Line 8114: oe_hold_definitions ohd,

8110: FROM DUAL
8111: WHERE EXISTS (SELECT NULL
8112: FROM oe_order_holds_all ooh,
8113: oe_hold_sources_all ohs,
8114: oe_hold_definitions ohd,
8115: oe_order_headers_all h,
8116: oe_order_sources oos
8117: WHERE ohd.hold_id = ohs.hold_id
8118: AND ooh.header_id = h.header_id

Line 8133: oe_hold_definitions ohd,

8129: FROM DUAL
8130: WHERE EXISTS (SELECT NULL
8131: FROM oe_order_holds_all ooh,
8132: oe_hold_sources_all ohs,
8133: oe_hold_definitions ohd,
8134: oe_order_headers_all h,
8135: oe_order_sources oos
8136: WHERE ohd.hold_id = ohs.hold_id
8137: AND ooh.org_id = p_org_id

Line 8151: oe_hold_definitions ohd

8147: SELECT 'Y'
8148: FROM DUAL
8149: WHERE EXISTS (SELECT NULL
8150: FROM oe_hold_sources_all ohs,
8151: oe_hold_definitions ohd
8152: WHERE ohd.hold_id = ohs.hold_id
8153: AND ohs.org_id = p_org_id
8154: AND ohs.hold_source_id = p_hld_src_id);
8155: --ER#7479609 end