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 114: return NVL(FND_GLOBAL.USER_ID, -1);

110: function get_user_id
111: return number
112: IS
113: BEGIN
114: return NVL(FND_GLOBAL.USER_ID, -1);
115: END get_user_id;
116:
117:
118: function entity_id_value (

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

5966: IS
5967: j NUMBER;
5968: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
5970: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
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)*/

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

5967: j NUMBER;
5968: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
5970: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
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;

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

6226: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
6227: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
6228: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6229: IS
6230: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6231: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
6233: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6234: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778

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

6227: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
6228: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6229: IS
6230: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6231: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
6233: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6234: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
6235: l_msg_token VARCHAR2(100); --8477694

Line 6333: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694

6329: IS
6330: l_order_rec OE_HOLDS_PVT.order_rec_type;
6331: --bug 5051532
6332: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
6333: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694
6334: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694
6335: l_msg_token VARCHAR2(100); --8477694
6336:
6337: BEGIN

Line 6334: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694

6330: l_order_rec OE_HOLDS_PVT.order_rec_type;
6331: --bug 5051532
6332: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
6333: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694
6334: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694
6335: l_msg_token VARCHAR2(100); --8477694
6336:
6337: BEGIN
6338: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6486: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694

6482: j NUMBER;
6483: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6484: l_order_rec OE_HOLDS_PVT.order_rec_type;
6485: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
6486: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694
6487: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694
6488: l_msg_token VARCHAR2(100); --8477694
6489:
6490: BEGIN

Line 6487: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694

6483: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6484: l_order_rec OE_HOLDS_PVT.order_rec_type;
6485: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
6486: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID; --8477694
6487: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID; --8477694
6488: l_msg_token VARCHAR2(100); --8477694
6489:
6490: BEGIN
6491: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6706: nextpos INTEGER;
6707:
6708: l_prev_org_id number;
6709: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

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

6707:
6708: l_prev_org_id number;
6709: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

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

6957: j INTEGER;
6958:
6959: L_prev_org_id number;
6960: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

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

6958:
6959: L_prev_org_id number;
6960: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
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;

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

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

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

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

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

7378: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7379: --l_record_ids varchar2(2000) := p_record_ids || ',';
7380: --l_num_of_records number;
7381:
7382: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7383: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7384: l_msg_token VARCHAR2(100);
7385: BEGIN
7386: oe_msg_pub.initialize;

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

7379: --l_record_ids varchar2(2000) := p_record_ids || ',';
7380: --l_num_of_records number;
7381:
7382: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7383: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7384: l_msg_token VARCHAR2(100);
7385: BEGIN
7386: oe_msg_pub.initialize;
7387:

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

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

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

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

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

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

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

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

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

7985:
7986: l_prev_org_id number;
7987: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7988: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7989: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7990: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7991: l_msg_token VARCHAR2(100);
7992: BEGIN
7993: oe_msg_pub.initialize;

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

7986: l_prev_org_id number;
7987: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7988: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7989: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7990: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7991: l_msg_token VARCHAR2(100);
7992: BEGIN
7993: oe_msg_pub.initialize;
7994:

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

8194: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8195: --l_record_ids varchar2(2000) := p_record_ids || ',';
8196: --l_num_of_records number;
8197:
8198: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8199: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8200: l_msg_token VARCHAR2(100);
8201: BEGIN
8202: oe_msg_pub.initialize;

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

8195: --l_record_ids varchar2(2000) := p_record_ids || ',';
8196: --l_num_of_records number;
8197:
8198: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8199: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8200: l_msg_token VARCHAR2(100);
8201: BEGIN
8202: oe_msg_pub.initialize;
8203:

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

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

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

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

Line 8727: FND_GLOBAL.RESP_APPL_ID;

8723:
8724: IS
8725:
8726: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
8727: FND_GLOBAL.RESP_APPL_ID;
8728: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
8729: := FND_GLOBAL.RESP_ID;
8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8731: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

Line 8729: := FND_GLOBAL.RESP_ID;

8725:
8726: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
8727: FND_GLOBAL.RESP_APPL_ID;
8728: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
8729: := FND_GLOBAL.RESP_ID;
8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8731: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8732: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
8733: l_msg_token VARCHAR2(100); --8477694