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_AUTHORIZATIONS

Line 688: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,

684: -- CHECK_AUTHORIZATION
685: -------------------------------------
686: function check_authorization (
687: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
688: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
689: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
690: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
691: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
692: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 689: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,

685: -------------------------------------
686: function check_authorization (
687: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
688: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
689: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
690: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
691: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
692: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
693: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 690: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,

686: function check_authorization (
687: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
688: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
689: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
690: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
691: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
692: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
693: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
694: )

Line 709: from oe_hold_authorizations

705: OE_Debug_PUB.Add('Application_Id' || to_char(p_application_id),1);
706: begin
707: select 'Y'
708: Into l_auth_exists
709: from oe_hold_authorizations
710: where hold_id = p_hold_id
711: and authorized_action_code = p_authorized_action_code
712: and rownum = 1;
713: Exception

Line 726: from oe_hold_authorizations

722: if l_auth_exists = 'Y' then
723: begin
724: select 'x'
725: into l_dummy
726: from oe_hold_authorizations
727: where sysdate between nvl(start_date_active,sysdate)
728: and nvl(end_date_active,sysdate)
729: and authorized_action_code = p_authorized_action_code
730: and responsibility_id = p_responsibility_id

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 7938: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=

7934: x_is_hold_applied OUT NOCOPY BOOLEAN )
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;

Line 7940: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE

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;
7944: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778