APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTERFACES_B

Line 863: FROM BNE_INTERFACES_B

859: ,CREATION_DATE
860: ,LAST_UPDATED_BY
861: ,LAST_UPDATE_LOGIN
862: ,LAST_UPDATE_DATE
863: FROM BNE_INTERFACES_B
864: WHERE application_id = p_application_id
865: AND INTERFACE_CODE = p_base_interface_code;
866:
867: l_interface_row c_interface_row%ROWTYPE;

Line 870: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

866:
867: l_interface_row c_interface_row%ROWTYPE;
868: l_rowid VARCHAR2(200);
869: no_default_layout EXCEPTION;
870: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
871: l_proc_name VARCHAR2(72) := g_proc_name||'Create_RIW_Interface_Row';
872:
873: BEGIN
874: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 886: FROM BNE_INTERFACES_B

882: -- Check that the OBJECT_CODE for this Interface is unique for the Application ID.
883: BEGIN
884: SELECT INTERFACE_CODE
885: INTO VV_INTERFACE_CODE
886: FROM BNE_INTERFACES_B
887: WHERE APPLICATION_ID = P_APPLICATION_ID
888: AND INTERFACE_CODE = p_new_interface_code;
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN NULL;

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

889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN NULL;
891: END;
892:
893: -- Create the interface in the BNE_INTERFACES_B table
894: IF (VV_INTERFACE_CODE IS NULL) THEN
895: INSERT INTO BNE_INTERFACES_B
896: (APPLICATION_ID
897: ,INTERFACE_CODE

Line 895: INSERT INTO BNE_INTERFACES_B

891: END;
892:
893: -- Create the interface in the BNE_INTERFACES_B table
894: IF (VV_INTERFACE_CODE IS NULL) THEN
895: INSERT INTO BNE_INTERFACES_B
896: (APPLICATION_ID
897: ,INTERFACE_CODE
898: ,OBJECT_VERSION_NUMBER
899: ,INTEGRATOR_APP_ID

Line 1649: select integrator_code from bne_interfaces_b where interface_code

1645:
1646: --$ get Integrator Code to delete entire integrator setup in one shot using
1647: -- Function bne_integrator_utils.DELETE_INTEGRATOR
1648: CURSOR csr_get_integrator_code is
1649: select integrator_code from bne_interfaces_b where interface_code
1650: = p_INTERFACE_CODE and application_id = p_application_id;
1651:
1652: l_proc varchar2(72) := g_package||'Delete_riw_integrator';
1653: l_intg_code varchar2(30);

Line 1731: FROM BNE_INTERFACES_B

1727: WHERE APPLICATION_ID = P_APPLICATION_ID
1728: AND INTERFACE_CODE = p_INTERFACE_CODE;
1729:
1730: DELETE
1731: FROM BNE_INTERFACES_B
1732: WHERE APPLICATION_ID = P_APPLICATION_ID
1733: AND INTERFACE_CODE = p_INTERFACE_CODE; */
1734: EXCEPTION
1735: WHEN OTHERS THEN