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_RELEASES

Line 1916: x_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

1912: l_count number;
1913: -- 16053361
1914:
1915: l_user_id NUMBER;
1916: x_hold_release_id oe_hold_releases.HOLD_RELEASE_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;

Line 1954: -- OE_HOLD_RELEASES with hold_source_id as null.

1950: x_msg_count => x_msg_count,
1951: x_msg_data => x_msg_data );
1952: ELSE
1953: -- Releasing only orders from hold. Insert a record in the
1954: -- OE_HOLD_RELEASES with hold_source_id as null.
1955: OE_Debug_PUB.Add('Releasing Orders from Hold',1);
1956: --x_hold_source_id := '';
1957:
1958: SELECT OE_HOLD_RELEASES_S.NEXTVAL

Line 1958: SELECT OE_HOLD_RELEASES_S.NEXTVAL

1954: -- OE_HOLD_RELEASES with hold_source_id as null.
1955: OE_Debug_PUB.Add('Releasing Orders from Hold',1);
1956: --x_hold_source_id := '';
1957:
1958: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1959: INTO x_hold_release_id
1960: FROM DUAL;
1961: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1962: INSERT INTO OE_HOLD_RELEASES

Line 1962: INSERT INTO OE_HOLD_RELEASES

1958: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1959: INTO x_hold_release_id
1960: FROM DUAL;
1961: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1962: INSERT INTO OE_HOLD_RELEASES
1963: ( HOLD_RELEASE_ID
1964: , CREATION_DATE
1965: , CREATED_BY
1966: , LAST_UPDATE_DATE

Line 5403: x_hold_release_id OUT NOCOPY /* file.sql.39 change */ oe_hold_releases.HOLD_RELEASE_ID%type,

5399:
5400:
5401: PROCEDURE Create_Release_Source (
5402: p_hold_release_rec IN OE_Holds_Pvt.Hold_Release_Rec_type,
5403: x_hold_release_id OUT NOCOPY /* file.sql.39 change */ oe_hold_releases.HOLD_RELEASE_ID%type,
5404: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5405: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5406: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5407: )

Line 5442: SELECT OE_HOLD_RELEASES_S.NEXTVAL

5438: RAISE FND_API.G_EXC_ERROR;
5439:
5440: END; -- Validate Reason Code
5441:
5442: SELECT OE_HOLD_RELEASES_S.NEXTVAL
5443: INTO x_hold_release_id
5444: FROM DUAL;
5445:
5446: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);

Line 5446: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);

5442: SELECT OE_HOLD_RELEASES_S.NEXTVAL
5443: INTO x_hold_release_id
5444: FROM DUAL;
5445:
5446: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
5447: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
5448: INSERT INTO OE_HOLD_RELEASES
5449: ( HOLD_RELEASE_ID
5450: , CREATION_DATE

Line 5448: INSERT INTO OE_HOLD_RELEASES

5444: FROM DUAL;
5445:
5446: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
5447: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
5448: INSERT INTO OE_HOLD_RELEASES
5449: ( HOLD_RELEASE_ID
5450: , CREATION_DATE
5451: , CREATED_BY
5452: , LAST_UPDATE_DATE

Line 5552: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

5548: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5549: )
5550: IS
5551: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
5552: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
5553: --
5554: CURSOR hold_source IS
5555: SELECT HS.HOLD_SOURCE_ID
5556: FROM OE_HOLD_SOURCES HS

Line 5771: -- release record also from OE_HOLD_RELEASES;

5767: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
5768: -- order, deletes hold source records from OE_HOLD_SOURCES.
5769: -- If the hold or hold source was released and the same release record is
5770: -- not used by an existing hold or hold source, then deletes the
5771: -- release record also from OE_HOLD_RELEASES;
5772: ----------------------------------------------------------------------------
5773: PROCEDURE Delete_Holds (
5774: p_order_rec IN OE_HOLDS_PVT.order_rec_Type,
5775: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 5838: DELETE FROM OE_HOLD_RELEASES

5834: DELETE FROM OE_ORDER_HOLDS_all
5835: WHERE order_hold_id = l_order_hold_id;
5836:
5837: OE_Debug_PUB.Add('Deleting hold release record',1);
5838: DELETE FROM OE_HOLD_RELEASES
5839: WHERE HOLD_RELEASE_ID = l_hold_release_id
5840: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
5841: FROM OE_ORDER_HOLDS_all
5842: UNION

Line 5863: DELETE FROM OE_HOLD_RELEASES

5859: DELETE FROM OE_HOLD_SOURCES_all
5860: WHERE HOLD_SOURCE_ID = l_hold_source_id;
5861:
5862: OE_Debug_PUB.Add('Deleting hold release record',1);
5863: DELETE FROM OE_HOLD_RELEASES
5864: WHERE HOLD_RELEASE_ID = l_hold_release_id
5865: AND HOLD_RELEASE_ID NOT IN
5866: ( SELECT NVL(HOLD_RELEASE_ID,0)
5867: FROM OE_ORDER_HOLDS_all

Line 5896: DELETE FROM OE_HOLD_RELEASES

5892:
5893: DELETE FROM OE_ORDER_HOLDS
5894: WHERE order_hold_id = l_order_hold_id;
5895:
5896: DELETE FROM OE_HOLD_RELEASES
5897: WHERE HOLD_RELEASE_ID = l_hold_release_id
5898: AND HOLD_RELEASE_ID NOT IN
5899: (SELECT NVL(HOLD_RELEASE_ID,0)
5900: FROM OE_ORDER_HOLDS_all

Line 6475: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

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,
6479: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 6476: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE,

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,
6479: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
6480: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 6567: -- from hold in oe_order_holds and insert record in oe_hold_releases with

6563: -- When release holds for orders, check to see if this order was put on
6564: -- hold as an
6565: -- Order based hold. If yes, then release the Hold_Source from hold and
6566: -- also order
6567: -- from hold in oe_order_holds and insert record in oe_hold_releases with
6568: -- order_hold_id(No with Hold Source ID).
6569: -- IF the order being releasesed is part of a different hold source (e.g. 'C')
6570: -- then don't release the hold source(what if its the last order)
6571: -- and only release the order from hold in

Line 6572: -- OE_ORDER_HOLDS and create a record in OE_HOLD_RELEASES with the

6568: -- order_hold_id(No with Hold Source ID).
6569: -- IF the order being releasesed is part of a different hold source (e.g. 'C')
6570: -- then don't release the hold source(what if its the last order)
6571: -- and only release the order from hold in
6572: -- OE_ORDER_HOLDS and create a record in OE_HOLD_RELEASES with the
6573: -- Order_Hold_ID.
6574: Validate_Order (p_order_tbl(j).header_id,
6575: p_order_tbl(j).line_id,
6576: x_return_status => x_return_status,

Line 7183: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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
7187: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7184: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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
7187: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7188: )

Line 7360: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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
7364: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7361: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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
7364: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7365: )

Line 7543: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

7539: IS
7540: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7541: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
7542: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
7543: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
7544: l_api_name CONSTANT VARCHAR2(30) := 'process_create_holds';
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);

Line 7965: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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
7969: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 7966: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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
7969: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7970: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 8175: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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
8179: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 8176: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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
8179: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
8180: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2