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 1579: x_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

1575: l_chk_hold VARCHAR2(1) := 'N';
1576: -- GENESIS --
1577:
1578: l_user_id NUMBER;
1579: x_hold_release_id oe_hold_releases.HOLD_RELEASE_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;

Line 1618: -- OE_HOLD_RELEASES with hold_source_id as null.

1614: x_msg_data => x_msg_data );
1615:
1616: ELSE
1617: -- Releasing only orders from hold. Insert a record in the
1618: -- OE_HOLD_RELEASES with hold_source_id as null.
1619: OE_Debug_PUB.Add('Releasing Orders from Hold',1);
1620: --x_hold_source_id := '';
1621:
1622: SELECT OE_HOLD_RELEASES_S.NEXTVAL

Line 1622: SELECT OE_HOLD_RELEASES_S.NEXTVAL

1618: -- OE_HOLD_RELEASES with hold_source_id as null.
1619: OE_Debug_PUB.Add('Releasing Orders from Hold',1);
1620: --x_hold_source_id := '';
1621:
1622: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1623: INTO x_hold_release_id
1624: FROM DUAL;
1625: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1626: INSERT INTO OE_HOLD_RELEASES

Line 1626: INSERT INTO OE_HOLD_RELEASES

1622: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1623: INTO x_hold_release_id
1624: FROM DUAL;
1625: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1626: INSERT INTO OE_HOLD_RELEASES
1627: ( HOLD_RELEASE_ID
1628: , CREATION_DATE
1629: , CREATED_BY
1630: , LAST_UPDATE_DATE

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

4844:
4845:
4846: PROCEDURE Create_Release_Source (
4847: p_hold_release_rec IN OE_Holds_Pvt.Hold_Release_Rec_type,
4848: x_hold_release_id OUT NOCOPY /* file.sql.39 change */ oe_hold_releases.HOLD_RELEASE_ID%type,
4849: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4850: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
4851: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4852: )

Line 4887: SELECT OE_HOLD_RELEASES_S.NEXTVAL

4883: RAISE FND_API.G_EXC_ERROR;
4884:
4885: END; -- Validate Reason Code
4886:
4887: SELECT OE_HOLD_RELEASES_S.NEXTVAL
4888: INTO x_hold_release_id
4889: FROM DUAL;
4890:
4891: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);

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

4887: SELECT OE_HOLD_RELEASES_S.NEXTVAL
4888: INTO x_hold_release_id
4889: FROM DUAL;
4890:
4891: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
4892: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
4893: INSERT INTO OE_HOLD_RELEASES
4894: ( HOLD_RELEASE_ID
4895: , CREATION_DATE

Line 4893: INSERT INTO OE_HOLD_RELEASES

4889: FROM DUAL;
4890:
4891: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
4892: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
4893: INSERT INTO OE_HOLD_RELEASES
4894: ( HOLD_RELEASE_ID
4895: , CREATION_DATE
4896: , CREATED_BY
4897: , LAST_UPDATE_DATE

Line 4997: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

4993: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4994: )
4995: IS
4996: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
4997: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
4998: --
4999: CURSOR hold_source IS
5000: SELECT HS.HOLD_SOURCE_ID
5001: FROM OE_HOLD_SOURCES HS

Line 5210: -- release record also from OE_HOLD_RELEASES;

5206: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
5207: -- order, deletes hold source records from OE_HOLD_SOURCES.
5208: -- If the hold or hold source was released and the same release record is
5209: -- not used by an existing hold or hold source, then deletes the
5210: -- release record also from OE_HOLD_RELEASES;
5211: ----------------------------------------------------------------------------
5212: PROCEDURE Delete_Holds (
5213: p_order_rec IN OE_HOLDS_PVT.order_rec_Type,
5214: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 5277: DELETE FROM OE_HOLD_RELEASES

5273: DELETE FROM OE_ORDER_HOLDS_all
5274: WHERE order_hold_id = l_order_hold_id;
5275:
5276: OE_Debug_PUB.Add('Deleting hold release record',1);
5277: DELETE FROM OE_HOLD_RELEASES
5278: WHERE HOLD_RELEASE_ID = l_hold_release_id
5279: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
5280: FROM OE_ORDER_HOLDS_all
5281: UNION

Line 5302: DELETE FROM OE_HOLD_RELEASES

5298: DELETE FROM OE_HOLD_SOURCES_all
5299: WHERE HOLD_SOURCE_ID = l_hold_source_id;
5300:
5301: OE_Debug_PUB.Add('Deleting hold release record',1);
5302: DELETE FROM OE_HOLD_RELEASES
5303: WHERE HOLD_RELEASE_ID = l_hold_release_id
5304: AND HOLD_RELEASE_ID NOT IN
5305: ( SELECT NVL(HOLD_RELEASE_ID,0)
5306: FROM OE_ORDER_HOLDS_all

Line 5335: DELETE FROM OE_HOLD_RELEASES

5331:
5332: DELETE FROM OE_ORDER_HOLDS
5333: WHERE order_hold_id = l_order_hold_id;
5334:
5335: DELETE FROM OE_HOLD_RELEASES
5336: WHERE HOLD_RELEASE_ID = l_hold_release_id
5337: AND HOLD_RELEASE_ID NOT IN
5338: (SELECT NVL(HOLD_RELEASE_ID,0)
5339: FROM OE_ORDER_HOLDS_all

Line 5781: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

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

Line 5782: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE,

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

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

5805: -- When release holds for orders, check to see if this order was put on
5806: -- hold as an
5807: -- Order based hold. If yes, then release the Hold_Source from hold and
5808: -- also order
5809: -- from hold in oe_order_holds and insert record in oe_hold_releases with
5810: -- order_hold_id(No with Hold Source ID).
5811: -- IF the order being releasesed is part of a different hold source (e.g. 'C')
5812: -- then don't release the hold source(what if its the last order)
5813: -- and only release the order from hold in

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

5810: -- order_hold_id(No with Hold Source ID).
5811: -- IF the order being releasesed is part of a different hold source (e.g. 'C')
5812: -- then don't release the hold source(what if its the last order)
5813: -- and only release the order from hold in
5814: -- OE_ORDER_HOLDS and create a record in OE_HOLD_RELEASES with the
5815: -- Order_Hold_ID.
5816: Validate_Order (p_order_tbl(j).header_id,
5817: p_order_tbl(j).line_id,
5818: x_return_status => x_return_status,

Line 6425: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 6426: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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

Line 6601: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 6602: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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

Line 6783: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;

6779: IS
6780: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6781: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
6782: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
6783: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
6784: l_api_name CONSTANT VARCHAR2(30) := 'process_create_holds';
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);

Line 7181: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 7182: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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

Line 7390: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 7391: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

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