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 FND_GLOBAL

Line 60: return NVL(FND_GLOBAL.USER_ID, -1);

56: function get_user_id
57: return number
58: IS
59: BEGIN
60: return NVL(FND_GLOBAL.USER_ID, -1);
61: END get_user_id;
62:
63:
64: function entity_id_value (

Line 5408: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

5404: IS
5405: j NUMBER;
5406: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5407: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
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;

Line 5409: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

5405: j NUMBER;
5406: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5407: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
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;

Line 5604: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

5600: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5601: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5602: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5603: IS
5604: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5605: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5606: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
5607: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5608: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778

Line 5605: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

5601: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5602: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5603: IS
5604: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5605: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5606: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
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)*/

Line 5954: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

5950: nextpos INTEGER;
5951:
5952: l_prev_org_id number;
5953: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

Line 5955: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

5951:
5952: l_prev_org_id number;
5953: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

Line 6204: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

6200: j INTEGER;
6201:
6202: L_prev_org_id number;
6203: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

Line 6205: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

6201:
6202: L_prev_org_id number;
6203: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

Line 6448: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

6444:
6445: l_prev_org_id number;
6446: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6447: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
6448: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6449: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6450: l_msg_token VARCHAR2(100);
6451: BEGIN
6452: oe_msg_pub.initialize;

Line 6449: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

6445: l_prev_org_id number;
6446: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6447: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
6448: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6449: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6450: l_msg_token VARCHAR2(100);
6451: BEGIN
6452: oe_msg_pub.initialize;
6453:

Line 6623: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

6619: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
6620: --l_record_ids varchar2(2000) := p_record_ids || ',';
6621: --l_num_of_records number;
6622:
6623: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6624: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6625: l_msg_token VARCHAR2(100);
6626: BEGIN
6627: oe_msg_pub.initialize;

Line 6624: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

6620: --l_record_ids varchar2(2000) := p_record_ids || ',';
6621: --l_num_of_records number;
6622:
6623: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6624: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6625: l_msg_token VARCHAR2(100);
6626: BEGIN
6627: oe_msg_pub.initialize;
6628:

Line 6785: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

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);
6788: /*Added the following variables for WF_HOLDS ER (bug 6449458)*/
6789: l_item_type OE_HOLD_DEFINITIONS.ITEM_TYPE%TYPE := NULL;

Line 6786: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

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);
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;

Line 7010: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

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
7014: l_msg_token VARCHAR2(100);

Line 7011: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

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
7014: l_msg_token VARCHAR2(100);
7015: BEGIN

Line 7205: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

7201:
7202: l_prev_org_id number;
7203: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7204: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7205: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7206: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7207: l_msg_token VARCHAR2(100);
7208: BEGIN
7209: oe_msg_pub.initialize;

Line 7206: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

7202: l_prev_org_id number;
7203: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7204: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7205: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7206: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7207: l_msg_token VARCHAR2(100);
7208: BEGIN
7209: oe_msg_pub.initialize;
7210:

Line 7413: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

7409: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7410: --l_record_ids varchar2(2000) := p_record_ids || ',';
7411: --l_num_of_records number;
7412:
7413: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7414: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7415: l_msg_token VARCHAR2(100);
7416: BEGIN
7417: oe_msg_pub.initialize;

Line 7414: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

7410: --l_record_ids varchar2(2000) := p_record_ids || ',';
7411: --l_num_of_records number;
7412:
7413: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7414: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7415: l_msg_token VARCHAR2(100);
7416: BEGIN
7417: oe_msg_pub.initialize;
7418:

Line 7600: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

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
7604: l_msg_token VARCHAR2(100);

Line 7601: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;

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
7604: l_msg_token VARCHAR2(100);
7605: BEGIN

Line 7939: FND_GLOBAL.RESP_APPL_ID;

7935:
7936: IS
7937:
7938: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
7939: FND_GLOBAL.RESP_APPL_ID;
7940: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
7941: := FND_GLOBAL.RESP_ID;
7942: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
7943: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

Line 7941: := FND_GLOBAL.RESP_ID;

7937:
7938: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
7939: FND_GLOBAL.RESP_APPL_ID;
7940: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
7941: := FND_GLOBAL.RESP_ID;
7942: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
7943: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7944: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
7945: