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 397: l_hold_name oe_hold_definitions.name%type := '';

393: function hold_name(
394: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)
395: return varchar2
396: IS
397: l_hold_name oe_hold_definitions.name%type := '';
398: BEGIN
399: select hd.name
400: into l_hold_name
401: from oe_hold_sources hs,

Line 402: oe_hold_definitions hd

398: BEGIN
399: select hd.name
400: into l_hold_name
401: from oe_hold_sources hs,
402: oe_hold_definitions hd
403: where hs.HOLD_SOURCE_ID = p_hold_source_id
404: and hs.hold_id = hd.hold_id;
405:
406: return l_hold_name;

Line 503: FROM oe_hold_definitions

499: -- Get the activity name on which the hold is defined
500: BEGIN
501: SELECT activity_name
502: INTO l_hold_activity
503: FROM oe_hold_definitions
504: WHERE hold_id = p_hold_id;
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN
507: Oe_debug_pub.ADD('Activity name not found!!');

Line 535: oe_hold_definitions hd

531: SELECT 'Y'
532: INTO l_release_children
533: FROM oe_order_holds oh,
534: oe_hold_sources hs,
535: oe_hold_definitions hd
536: WHERE hs.hold_source_id = oh.hold_source_id
537: AND hs.hold_id = hd.hold_id
538: AND hd.hold_id = p_hold_id
539: AND oh.header_id = p_order_tbl(1).header_id

Line 799: FROM oe_hold_definitions hd, oe_hold_sources hs

795: -- Get the activity name on which the hold is defined
796: BEGIN
797: SELECT hd.activity_name
798: INTO l_hold_activity
799: FROM oe_hold_definitions hd, oe_hold_sources hs
800: WHERE hd.hold_id = hs.hold_id
801: AND hs.hold_source_id = p_hold_source_id;
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN

Line 961: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

957: -------------------------------------
958: -- CHECK_AUTHORIZATION
959: -------------------------------------
960: function check_authorization (
961: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
962: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
963: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
964: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
965: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1879: oe_hold_definitions ohd,

1875: FROM DUAL
1876: WHERE EXISTS (SELECT NULL
1877: FROM oe_order_holds ooh,
1878: oe_hold_sources ohs,
1879: oe_hold_definitions ohd,
1880: oe_order_headers_all h,
1881: oe_order_sources oos
1882: WHERE ooh.header_id = h.header_id
1883: -- AND ohd.activity_name IS NULL Bug 6791587

Line 1921: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;

1917: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1918: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1919: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;
1920: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
1921: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;
1922:
1923: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
1924: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1925: BEGIN

Line 2159: from oe_hold_definitions

2155: is
2156: select
2157: item_type
2158: , nvl(apply_to_order_and_line_flag, 'N')
2159: from oe_hold_definitions
2160: where hold_id = l_hold_id;
2161:
2162: BEGIN
2163: OE_Debug_PUB.Add('In OE_holds_PUB.Validate_Hold_source',1);

Line 2711: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_id%TYPE,

2707:
2708:
2709: -----------------------
2710: Procedure Validate_Hold (
2711: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_id%TYPE,
2712: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2713: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2714: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2715: IS

Line 2734: FROM OE_HOLD_DEFINITIONS

2730:
2731: BEGIN
2732: SELECT 'x'
2733: INTO l_dummy
2734: FROM OE_HOLD_DEFINITIONS
2735: WHERE HOLD_ID = p_hold_id
2736: AND SYSDATE
2737: BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
2738: AND NVL(END_DATE_ACTIVE, SYSDATE );

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

3283: l_api_name CONSTANT VARCHAR2(30) := 'Create_Order_Holds';
3284: l_site_use_code VARCHAR2(30);
3285: /*Added the three variables for WF_HOLDS bug 6449458*/
3286: l_is_hold_applied BOOLEAN DEFAULT NULL;
3287: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
3288: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
3289:
3290:
3291: /* Moved to Overloaded Procedure under Bug 6801108

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

3284: l_site_use_code VARCHAR2(30);
3285: /*Added the three variables for WF_HOLDS bug 6449458*/
3286: l_is_hold_applied BOOLEAN DEFAULT NULL;
3287: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
3288: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
3289:
3290:
3291: /* Moved to Overloaded Procedure under Bug 6801108
3292: -- GENESIS --

Line 3301: oe_hold_definitions ohd,

3297: FROM DUAL
3298: WHERE EXISTS (SELECT NULL
3299: FROM oe_order_holds ooh,
3300: oe_hold_sources ohs,
3301: oe_hold_definitions ohd,
3302: oe_order_headers_all h,
3303: oe_order_sources oos
3304: WHERE ohd.activity_name IS NULL
3305: AND ohd.hold_id = ohs.hold_id

Line 3318: oe_hold_definitions ohd,

3314: FROM DUAL
3315: WHERE EXISTS (SELECT NULL
3316: FROM oe_order_holds ooh,
3317: oe_hold_sources ohs,
3318: oe_hold_definitions ohd,
3319: oe_order_headers_all h,
3320: oe_order_sources oos
3321: WHERE ohd.activity_name IS NULL
3322: AND ohd.hold_id = ohs.hold_id

Line 3334: oe_hold_definitions ohd

3330: SELECT 'Y'
3331: FROM DUAL
3332: WHERE EXISTS (SELECT NULL
3333: FROM oe_hold_sources ohs,
3334: oe_hold_definitions ohd
3335: WHERE ohd.activity_name IS NULL
3336: AND ohd.hold_id = ohs.hold_id
3337: AND ohs.hold_source_id = p_hld_src_id);
3338:

Line 3359: from oe_hold_definitions

3355:
3356: Begin
3357: select item_type, activity_name
3358: into l_wf_item_type, l_wf_activity_name
3359: from oe_hold_definitions
3360: where hold_id = p_hold_source_rec.hold_id;
3361: Exception
3362: When NO_DATA_FOUND Then
3363: NULL; -- OE_Holds_Pvt.Validate has not yet been called.

Line 5245: oe_hold_definitions ohd

5241: SELECT 'Y'
5242: FROM DUAL
5243: WHERE EXISTS (SELECT NULL
5244: FROM oe_hold_sources ohs,
5245: oe_hold_definitions ohd
5246: WHERE ohd.hold_id = ohs.hold_id
5247: -- AND ohd.activity_name IS NULL Bug 6791587
5248: AND ohs.hold_source_id = p_hld_src_id
5249: AND ohs.hold_entity_code <> 'O');

Line 5959: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

5955:
5956: --------------------
5957: Procedure Apply_Holds (
5958: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
5959: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
5960: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE,
5961: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE,
5962: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
5963: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

5971: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5972: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5973: l_msg_token VARCHAR2(100); --8477694
5974: /*Added the Following Variables for WF_HOLDS ER (bug 6449458)*/
5975: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5976: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5977: l_is_hold_applied BOOLEAN;
5978: l_count_of_holds_applied NUMBER := 0;
5979: l_user_activity_name VARCHAR2(80);

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

5972: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5973: l_msg_token VARCHAR2(100); --8477694
5974: /*Added the Following Variables for WF_HOLDS ER (bug 6449458)*/
5975: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
5976: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
5977: l_is_hold_applied BOOLEAN;
5978: l_count_of_holds_applied NUMBER := 0;
5979: l_user_activity_name VARCHAR2(80);
5980:

Line 6135: from oe_hold_definitions

6131: for WF_HOLDS ER (bug 6449458)*/
6132: IF l_wf_item_type IS NULL AND l_wf_activity_name IS NULL THEN
6133: select item_type, activity_name
6134: into l_wf_item_type, l_wf_activity_name
6135: from oe_hold_definitions
6136: where hold_id = l_hold_source_rec.hold_id;
6137: END IF;
6138:
6139: IF l_wf_item_type IS NOT NULL AND l_wf_activity_name IS NOT

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

6234: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
6235: l_msg_token VARCHAR2(100); --8477694
6236: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/
6237: l_hold_msg_applied BOOLEAN DEFAULT NULL;
6238: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6239: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6240:
6241: BEGIN
6242:

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

6235: l_msg_token VARCHAR2(100); --8477694
6236: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/
6237: l_hold_msg_applied BOOLEAN DEFAULT NULL;
6238: l_wf_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6239: l_wf_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6240:
6241: BEGIN
6242:
6243:

Line 6248: from oe_hold_definitions

6244:
6245: Begin
6246: select item_type, activity_name
6247: into l_wf_item_type, l_wf_activity_name
6248: from oe_hold_definitions
6249: where hold_id = p_hold_source_rec.hold_id;
6250: Exception
6251: When NO_DATA_FOUND Then
6252: NULL; -- OE_Holds_Pvt.Validate has not yet been called.

Line 6474: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

6470:
6471: ---------------------
6472: Procedure Release_Holds (
6473: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
6474: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
6475: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
6476: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE,
6477: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
6478: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 6687: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

6683:
6684: procedure process_apply_holds_lines (
6685: p_num_of_records IN NUMBER
6686: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6687: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6688: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6689: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6690: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6691: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

6710: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6711: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6712: l_msg_token VARCHAR2(100);
6713: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6714: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6715: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6716: l_is_hold_applied BOOLEAN;
6717: l_count_of_holds_applied NUMBER := 0;
6718: l_user_activity_name VARCHAR2(80);

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

6711: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6712: l_msg_token VARCHAR2(100);
6713: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6714: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6715: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6716: l_is_hold_applied BOOLEAN;
6717: l_count_of_holds_applied NUMBER := 0;
6718: l_user_activity_name VARCHAR2(80);
6719:

Line 6803: from oe_hold_definitions

6799: /*Added the IF condition for WF_HOLDS ER (bug 6449458)*/
6800: IF l_item_type IS NULL AND l_activity_name IS NULL THEN
6801: select item_type, activity_name
6802: into l_item_type, l_activity_name
6803: from oe_hold_definitions
6804: where hold_id = l_hold_source_rec.hold_id;
6805: END IF;
6806:
6807: OE_DEBUG_PUB.Add('Before calling oe_holds_pvt.apply_holds');

Line 6941: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

6937: /*=================================*/
6938: procedure process_apply_holds_orders (
6939: p_num_of_records IN NUMBER
6940: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6941: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6942: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6943: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6944: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6945: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

6961: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6962: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6963: l_msg_token VARCHAR2(100);
6964: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6965: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6966: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6967: l_is_hold_applied BOOLEAN;
6968: l_count_of_holds_applied NUMBER := 0;
6969: l_user_activity_name VARCHAR2(80);

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

6962: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6963: l_msg_token VARCHAR2(100);
6964: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6965: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
6966: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
6967: l_is_hold_applied BOOLEAN;
6968: l_count_of_holds_applied NUMBER := 0;
6969: l_user_activity_name VARCHAR2(80);
6970:

Line 7047: from oe_hold_definitions

7043: /*Added the IF condition for WF_HOLDS ER (bug 6449458)*/
7044: IF l_item_type IS NULL AND l_activity_name IS NULL THEN
7045: select item_type, activity_name
7046: into l_item_type, l_activity_name
7047: from oe_hold_definitions
7048: where hold_id = l_hold_source_rec.hold_id;
7049: END IF;
7050:
7051: OE_DEBUG_PUB.Add('Before calling oe_holds_pvt.apply_holds');

Line 7182: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

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

Line 7359: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

7355: */
7356: procedure process_release_holds_orders (
7357: p_num_of_records IN NUMBER
7358: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7359: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7360: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7361: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7362: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7363: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

7545: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7546: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7547: l_msg_token VARCHAR2(100);
7548: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
7549: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
7550: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
7551: l_is_hold_applied BOOLEAN;
7552: l_count_of_holds_applied NUMBER := 0;
7553:

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

7546: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7547: l_msg_token VARCHAR2(100);
7548: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
7549: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;
7550: l_activity_name OE_HOLD_DEFINITIONS.ACTIVITY_NAME%TYPE := NULL;
7551: l_is_hold_applied BOOLEAN;
7552: l_count_of_holds_applied NUMBER := 0;
7553:
7554: --

Line 7632: from oe_hold_definitions

7628: oe_debug_pub.add('p_hold_future_flg->' || p_hold_future_flg,3);
7629: /*added the select statement for WF_HOLDS ER (bug 6449458)*/
7630: select item_type, activity_name
7631: into l_item_type, l_activity_name
7632: from oe_hold_definitions
7633: where hold_id = l_hold_source_rec.hold_id;
7634:
7635: if (p_hold_existing_flg = 'Y' AND p_hold_future_flg = 'Y') then
7636: oe_debug_pub.add('Calling oe_holds_pvt.apply_Holds',3);

Line 7792: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;

7788: IS
7789: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7790: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7791: l_api_name CONSTANT VARCHAR2(30) := 'process_release_source';
7792: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
7793: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7794: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7795: --ER#7479609 l_hold_entity_code varchar2(1); /* Added for Bug 1946783 */
7796: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

Line 7964: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

7960:
7961: procedure process_release_holds_lines (
7962: p_num_of_records IN NUMBER
7963: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7964: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7965: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7966: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7967: , p_wf_release_action IN VARCHAR2
7968: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 8174: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

8170:
8171: procedure process_release_holds_orders (
8172: p_num_of_records IN NUMBER
8173: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
8174: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
8175: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
8176: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
8177: , p_wf_release_action IN VARCHAR2
8178: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 8385: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;

8381: IS
8382: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8383: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8384: l_api_name CONSTANT VARCHAR2(30) := 'process_release_source';
8385: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
8386: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8387: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8388: --ER#7479609 l_hold_entity_code VARCHAR2(1); /* Added for Bug 1946783 */
8389: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

Line 8924: oe_hold_definitions ohd,

8920: FROM DUAL
8921: WHERE EXISTS (SELECT NULL
8922: FROM oe_order_holds ooh,
8923: oe_hold_sources ohs,
8924: oe_hold_definitions ohd,
8925: oe_order_headers_all h,
8926: oe_order_sources oos
8927: WHERE ohd.hold_id = ohs.hold_id
8928: -- AND ohd.activity_name IS NULL Bug 6791587

Line 8941: oe_hold_definitions ohd,

8937: FROM DUAL
8938: WHERE EXISTS (SELECT NULL
8939: FROM oe_order_holds ooh,
8940: oe_hold_sources ohs,
8941: oe_hold_definitions ohd,
8942: oe_order_headers_all h,
8943: oe_order_sources oos
8944: WHERE ohd.hold_id = ohs.hold_id
8945: -- AND ohd.activity_name IS NULL Bug 6791587

Line 8957: oe_hold_definitions ohd

8953: SELECT 'Y'
8954: FROM DUAL
8955: WHERE EXISTS (SELECT NULL
8956: FROM oe_hold_sources ohs,
8957: oe_hold_definitions ohd
8958: WHERE ohd.hold_id = ohs.hold_id
8959: --AND ohd.activity_name IS NULL Bug 6791587
8960: AND ohs.hold_source_id = p_hld_src_id);
8961: ER#7479609*/

Line 8970: oe_hold_definitions ohd,

8966: FROM DUAL
8967: WHERE EXISTS (SELECT NULL
8968: FROM oe_order_holds_all ooh,
8969: oe_hold_sources_all ohs,
8970: oe_hold_definitions ohd,
8971: oe_order_headers_all h,
8972: oe_order_sources oos
8973: WHERE ohd.hold_id = ohs.hold_id
8974: AND ooh.header_id = h.header_id

Line 8989: oe_hold_definitions ohd,

8985: FROM DUAL
8986: WHERE EXISTS (SELECT NULL
8987: FROM oe_order_holds_all ooh,
8988: oe_hold_sources_all ohs,
8989: oe_hold_definitions ohd,
8990: oe_order_headers_all h,
8991: oe_order_sources oos
8992: WHERE ohd.hold_id = ohs.hold_id
8993: AND ooh.org_id = p_org_id

Line 9007: oe_hold_definitions ohd

9003: SELECT 'Y'
9004: FROM DUAL
9005: WHERE EXISTS (SELECT NULL
9006: FROM oe_hold_sources_all ohs,
9007: oe_hold_definitions ohd
9008: WHERE ohd.hold_id = ohs.hold_id
9009: AND ohs.org_id = p_org_id
9010: AND ohs.hold_source_id = p_hld_src_id);
9011: --ER#7479609 end