APPS.BNE_CONTENT_UTILS dependencies on BNE_STORED_SQL

Line 668: -- BNE_STORED_SQL table. --

664: --------------------------------------------------------------------------------
665: -- PROCEDURE: UPSERT_STORED_SQL_STATEMENT --
666: -- --
667: -- DESCRIPTION: Procedure inserts or updates a single row in the --
668: -- BNE_STORED_SQL table. --
669: -- This procedure will only update the QUERY column value. --
670: -- The record to be inserted/updated will be determined by --
671: -- the APPLICATION_ID and CONTENT_CODE parameters. --
672: -- --

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

681: P_USER_ID IN NUMBER)
682: IS
683: VN_NO_RECORD_FLAG NUMBER;
684: BEGIN
685: -- Check the BNE_STORED_SQL table to ensure that the SQL Query for this
686: -- APPLICATION_ID and CONTENT_CODE does not already exist
687:
688: VN_NO_RECORD_FLAG := 0;
689:

Line 693: FROM BNE_STORED_SQL

689:
690: BEGIN
691: SELECT 1
692: INTO VN_NO_RECORD_FLAG
693: FROM BNE_STORED_SQL
694: WHERE APPLICATION_ID = P_APPLICATION_ID
695: AND CONTENT_CODE = P_CONTENT_CODE;
696: EXCEPTION
697: WHEN NO_DATA_FOUND THEN NULL;

Line 704: -- Insert the required row in BNE_STORED_SQL

700: -- If the SQL query was not found then insert it
701:
702: IF (VN_NO_RECORD_FLAG = 0) THEN
703:
704: -- Insert the required row in BNE_STORED_SQL
705:
706: INSERT INTO BNE_STORED_SQL
707: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, QUERY, CREATED_BY, CREATION_DATE,
708: LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 706: INSERT INTO BNE_STORED_SQL

702: IF (VN_NO_RECORD_FLAG = 0) THEN
703:
704: -- Insert the required row in BNE_STORED_SQL
705:
706: INSERT INTO BNE_STORED_SQL
707: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, QUERY, CREATED_BY, CREATION_DATE,
708: LAST_UPDATED_BY, LAST_UPDATE_DATE)
709: VALUES
710: (P_APPLICATION_ID, P_CONTENT_CODE, 1, P_QUERY, P_USER_ID, SYSDATE,

Line 715: -- Update the required row in BNE_STORED_SQL

711: P_USER_ID, SYSDATE);
712:
713: ELSE
714:
715: -- Update the required row in BNE_STORED_SQL
716:
717: UPDATE BNE_STORED_SQL
718: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
719: QUERY = P_QUERY,

Line 717: UPDATE BNE_STORED_SQL

713: ELSE
714:
715: -- Update the required row in BNE_STORED_SQL
716:
717: UPDATE BNE_STORED_SQL
718: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
719: QUERY = P_QUERY,
720: LAST_UPDATED_BY = P_USER_ID,
721: LAST_UPDATE_DATE = SYSDATE,