APPS.BNE_CONTENT_UTILS dependencies on BNE_STORED_SQL

Line 706: -- BNE_STORED_SQL table. --

702: --------------------------------------------------------------------------------
703: -- PROCEDURE: UPSERT_STORED_SQL_STATEMENT --
704: -- --
705: -- DESCRIPTION: Procedure inserts or updates a single row in the --
706: -- BNE_STORED_SQL table. --
707: -- This procedure will only update the QUERY column value. --
708: -- The record to be inserted/updated will be determined by --
709: -- the APPLICATION_ID and CONTENT_CODE parameters. --
710: -- --

Line 723: -- Check the BNE_STORED_SQL table to ensure that the SQL Query for this

719: P_USER_ID IN NUMBER)
720: IS
721: VN_NO_RECORD_FLAG NUMBER;
722: BEGIN
723: -- Check the BNE_STORED_SQL table to ensure that the SQL Query for this
724: -- APPLICATION_ID and CONTENT_CODE does not already exist
725:
726: VN_NO_RECORD_FLAG := 0;
727:

Line 731: FROM BNE_STORED_SQL

727:
728: BEGIN
729: SELECT 1
730: INTO VN_NO_RECORD_FLAG
731: FROM BNE_STORED_SQL
732: WHERE APPLICATION_ID = P_APPLICATION_ID
733: AND CONTENT_CODE = P_CONTENT_CODE;
734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN NULL;

Line 742: -- Insert the required row in BNE_STORED_SQL

738: -- If the SQL query was not found then insert it
739:
740: IF (VN_NO_RECORD_FLAG = 0) THEN
741:
742: -- Insert the required row in BNE_STORED_SQL
743:
744: INSERT INTO BNE_STORED_SQL
745: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, QUERY, CREATED_BY, CREATION_DATE,
746: LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 744: INSERT INTO BNE_STORED_SQL

740: IF (VN_NO_RECORD_FLAG = 0) THEN
741:
742: -- Insert the required row in BNE_STORED_SQL
743:
744: INSERT INTO BNE_STORED_SQL
745: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, QUERY, CREATED_BY, CREATION_DATE,
746: LAST_UPDATED_BY, LAST_UPDATE_DATE)
747: VALUES
748: (P_APPLICATION_ID, P_CONTENT_CODE, 1, P_QUERY, P_USER_ID, SYSDATE,

Line 753: -- Update the required row in BNE_STORED_SQL

749: P_USER_ID, SYSDATE);
750:
751: ELSE
752:
753: -- Update the required row in BNE_STORED_SQL
754:
755: UPDATE BNE_STORED_SQL
756: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
757: QUERY = P_QUERY,

Line 755: UPDATE BNE_STORED_SQL

751: ELSE
752:
753: -- Update the required row in BNE_STORED_SQL
754:
755: UPDATE BNE_STORED_SQL
756: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
757: QUERY = P_QUERY,
758: LAST_UPDATED_BY = P_USER_ID,
759: LAST_UPDATE_DATE = SYSDATE,