APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTERFACES_B

Line 1132: FROM BNE_INTERFACES_B

1128: ,CREATION_DATE
1129: ,LAST_UPDATED_BY
1130: ,LAST_UPDATE_LOGIN
1131: ,LAST_UPDATE_DATE
1132: FROM BNE_INTERFACES_B
1133: WHERE application_id = p_application_id
1134: AND INTERFACE_CODE = p_base_interface_code;
1135:
1136: l_interface_row c_interface_row%ROWTYPE;

Line 1139: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

1135:
1136: l_interface_row c_interface_row%ROWTYPE;
1137: l_rowid VARCHAR2(200);
1138: no_default_layout EXCEPTION;
1139: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1140: l_proc_name VARCHAR2(72) := g_proc_name||'Create_RIW_Interface_Row';
1141:
1142: BEGIN
1143: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1155: FROM BNE_INTERFACES_B

1151: -- Check that the OBJECT_CODE for this Interface is unique for the Application ID.
1152: BEGIN
1153: SELECT INTERFACE_CODE
1154: INTO VV_INTERFACE_CODE
1155: FROM BNE_INTERFACES_B
1156: WHERE APPLICATION_ID = P_APPLICATION_ID
1157: AND INTERFACE_CODE = p_new_interface_code;
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN NULL;

Line 1162: -- Create the interface in the BNE_INTERFACES_B table

1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN NULL;
1160: END;
1161:
1162: -- Create the interface in the BNE_INTERFACES_B table
1163: IF (VV_INTERFACE_CODE IS NULL) THEN
1164: INSERT INTO BNE_INTERFACES_B
1165: (APPLICATION_ID
1166: ,INTERFACE_CODE

Line 1164: INSERT INTO BNE_INTERFACES_B

1160: END;
1161:
1162: -- Create the interface in the BNE_INTERFACES_B table
1163: IF (VV_INTERFACE_CODE IS NULL) THEN
1164: INSERT INTO BNE_INTERFACES_B
1165: (APPLICATION_ID
1166: ,INTERFACE_CODE
1167: ,OBJECT_VERSION_NUMBER
1168: ,INTEGRATOR_APP_ID

Line 1932: select integrator_code from bne_interfaces_b where interface_code

1928:
1929: --$ get Integrator Code to delete entire integrator setup in one shot using
1930: -- Function bne_integrator_utils.DELETE_INTEGRATOR
1931: CURSOR csr_get_integrator_code is
1932: select integrator_code from bne_interfaces_b where interface_code
1933: = p_INTERFACE_CODE and application_id = p_application_id;
1934:
1935: l_proc varchar2(72) := g_package||'Delete_riw_integrator';
1936: l_intg_code varchar2(30);

Line 2014: FROM BNE_INTERFACES_B

2010: WHERE APPLICATION_ID = P_APPLICATION_ID
2011: AND INTERFACE_CODE = p_INTERFACE_CODE;
2012:
2013: DELETE
2014: FROM BNE_INTERFACES_B
2015: WHERE APPLICATION_ID = P_APPLICATION_ID
2016: AND INTERFACE_CODE = p_INTERFACE_CODE; */
2017: EXCEPTION
2018: WHEN OTHERS THEN