APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUTS_B

Line 2047: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUTS_B

2043: else
2044:
2045: VN_ROW_COUNT:=0;
2046: BEGIN
2047: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUTS_B
2048: WHERE APPLICATION_ID = P_APPLICATION_ID
2049: AND LAYOUT_CODE = P_LAYOUT_CODE;
2050: EXCEPTION
2051: WHEN NO_DATA_FOUND THEN NULL;

Line 2054: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUTS_B for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');

2050: EXCEPTION
2051: WHEN NO_DATA_FOUND THEN NULL;
2052: END;
2053: IF VN_ROW_COUNT > 0 THEN
2054: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUTS_B for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2055: END IF;
2056:
2057: VN_ROW_COUNT:=0;
2058: BEGIN

Line 4968: FROM BNE_LAYOUTS_B

4964: VV_COUNT NUMBER;
4965: BEGIN
4966: VV_COUNT := 0;
4967: FOR I IN (SELECT APPLICATION_ID, LAYOUT_CODE
4968: FROM BNE_LAYOUTS_B
4969: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4970: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4971: LOOP
4972: VV_COUNT := VV_COUNT + DELETE_LAYOUT(I.APPLICATION_ID, I.LAYOUT_CODE);

Line 5006: FROM BNE_LAYOUTS_B

5002: VV_COUNT NUMBER;
5003: BEGIN
5004: SELECT COUNT(*)
5005: INTO VV_COUNT
5006: FROM BNE_LAYOUTS_B
5007: WHERE APPLICATION_ID = P_APPLICATION_ID
5008: AND LAYOUT_CODE = P_LAYOUT_CODE;
5009:
5010: IF VV_COUNT = 0

Line 5015: DELETE FROM BNE_LAYOUTS_B

5011: THEN
5012: RETURN(0);
5013: END IF;
5014:
5015: DELETE FROM BNE_LAYOUTS_B
5016: WHERE APPLICATION_ID = P_APPLICATION_ID
5017: AND LAYOUT_CODE = P_LAYOUT_CODE;
5018:
5019: DELETE FROM BNE_LAYOUTS_TL

Line 5621: FROM BNE_LAYOUTS_B

5617:
5618: --
5619: SELECT COUNT(*)
5620: INTO VV_DUMMY
5621: FROM BNE_LAYOUTS_B
5622: WHERE CREATE_DOC_LIST_APP_ID = P_APPLICATION_ID
5623: AND CREATE_DOC_LIST_CODE = P_PARAM_LIST_CODE;
5624:
5625: IF VV_DUMMY > 0