958: -- CHECK_AUTHORIZATION
959: -------------------------------------
960: function check_authorization (
961: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
962: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
963: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
964: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
965: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
966: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
959: -------------------------------------
960: function check_authorization (
961: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
962: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
963: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
964: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
965: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
966: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
967: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
960: function check_authorization (
961: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
962: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
963: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
964: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
965: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
966: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
967: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
968: )
979: OE_Debug_PUB.Add('Application_Id' || to_char(p_application_id),1);
980: begin
981: select 'Y'
982: Into l_auth_exists
983: from oe_hold_authorizations
984: where hold_id = p_hold_id
985: and authorized_action_code = p_authorized_action_code
986: and rownum = 1;
987: Exception
996: if l_auth_exists = 'Y' then
997: begin
998: select 'x'
999: into l_dummy
1000: from oe_hold_authorizations
1001: where sysdate between nvl(start_date_active,sysdate)
1002: and nvl(end_date_active,sysdate)
1003: and authorized_action_code = p_authorized_action_code
1004: and responsibility_id = p_responsibility_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)*/
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;
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
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
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
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;
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
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;
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;
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;
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;
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;
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;
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:
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;
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:
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;
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;
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);
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
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;
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:
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;
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:
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);
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
8722: x_is_hold_applied OUT NOCOPY BOOLEAN )
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;
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;
8732: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778