APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUTS_B

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

1952: else
1953:
1954: VN_ROW_COUNT:=0;
1955: BEGIN
1956: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUTS_B
1957: WHERE APPLICATION_ID = P_APPLICATION_ID
1958: AND LAYOUT_CODE = P_LAYOUT_CODE;
1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN NULL;

Line 1963: 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.');

1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN NULL;
1961: END;
1962: IF VN_ROW_COUNT > 0 THEN
1963: 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.');
1964: END IF;
1965:
1966: VN_ROW_COUNT:=0;
1967: BEGIN

Line 4877: FROM BNE_LAYOUTS_B

4873: VV_COUNT NUMBER;
4874: BEGIN
4875: VV_COUNT := 0;
4876: FOR I IN (SELECT APPLICATION_ID, LAYOUT_CODE
4877: FROM BNE_LAYOUTS_B
4878: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4879: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4880: LOOP
4881: VV_COUNT := VV_COUNT + DELETE_LAYOUT(I.APPLICATION_ID, I.LAYOUT_CODE);

Line 4915: FROM BNE_LAYOUTS_B

4911: VV_COUNT NUMBER;
4912: BEGIN
4913: SELECT COUNT(*)
4914: INTO VV_COUNT
4915: FROM BNE_LAYOUTS_B
4916: WHERE APPLICATION_ID = P_APPLICATION_ID
4917: AND LAYOUT_CODE = P_LAYOUT_CODE;
4918:
4919: IF VV_COUNT = 0

Line 4924: DELETE FROM BNE_LAYOUTS_B

4920: THEN
4921: RETURN(0);
4922: END IF;
4923:
4924: DELETE FROM BNE_LAYOUTS_B
4925: WHERE APPLICATION_ID = P_APPLICATION_ID
4926: AND LAYOUT_CODE = P_LAYOUT_CODE;
4927:
4928: DELETE FROM BNE_LAYOUTS_TL

Line 5536: FROM BNE_LAYOUTS_B

5532:
5533: --
5534: SELECT COUNT(*)
5535: INTO VV_DUMMY
5536: FROM BNE_LAYOUTS_B
5537: WHERE CREATE_DOC_LIST_APP_ID = P_APPLICATION_ID
5538: AND CREATE_DOC_LIST_CODE = P_PARAM_LIST_CODE;
5539:
5540: IF VV_DUMMY > 0