APPS.JTF_OBJECTS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

   FUNCTION jtf_obj_select_stmt (
      select_id         IN   jtf_objects_b.select_id%TYPE DEFAULT NULL,
      select_name       IN   jtf_objects_b.select_name%TYPE DEFAULT NULL,
      select_details    IN   jtf_objects_b.select_details%TYPE DEFAULT NULL,
      from_table        IN   jtf_objects_b.from_table%TYPE DEFAULT NULL,
      where_clause      IN   jtf_objects_b.where_clause%TYPE DEFAULT NULL,
      p_inactive_clause IN   jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
      order_by_clause   IN   jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
      )
      RETURN VARCHAR2
   IS
      l_select_id         jtf_objects_b.select_id%TYPE       := select_id;

Line: 30

      l_select_name       jtf_objects_b.select_name%TYPE     := select_name;

Line: 31

      l_select_details    jtf_objects_b.select_details%TYPE
               := select_details;

Line: 46

      IF l_select_id IS NULL
      THEN
         IF l_select_name IS NULL
         THEN
            IF l_select_details IS NULL
            THEN
               RETURN NULL;

Line: 54

               str := 'select ' || l_select_details;

Line: 57

            IF l_select_details IS NULL
            THEN
               str := 'select ' || l_select_name;

Line: 61

               str := 'select ' || l_select_name || ', ' || l_select_details;

Line: 65

         IF l_select_name IS NULL
         THEN
            IF l_select_details IS NULL
            THEN
               str := 'select ' || l_select_id;

Line: 71

               str := 'select ' || l_select_id || ', ' || l_select_details;

Line: 74

            IF l_select_details IS NULL
            THEN
               str := 'select ' || l_select_id || ', ' || l_select_name;

Line: 78

               str := 'select ' ||
                      l_select_id ||
                      ', ' ||
                      l_select_name ||
                      ', ' ||
                      l_select_details;

Line: 110

   END jtf_obj_select_stmt;

Line: 116

      p_select_id         IN       jtf_objects_b.select_id%TYPE DEFAULT NULL,
      p_select_name       IN       jtf_objects_b.select_name%TYPE DEFAULT NULL,
      p_select_details    IN       jtf_objects_b.select_details%TYPE
            DEFAULT NULL,
      p_from_table        IN       jtf_objects_b.from_table%TYPE DEFAULT NULL,
      p_where_clause      IN       jtf_objects_b.where_clause%TYPE
            DEFAULT NULL,
      p_inactive_clause   IN       jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586
      p_order_by_clause   IN       jtf_objects_b.order_by_clause%TYPE
            DEFAULT NULL,
      x_return_status     OUT NOCOPY      VARCHAR2,
      x_msg_count         OUT NOCOPY      NUMBER,
      x_msg_data          OUT NOCOPY      VARCHAR2,
      x_sql_statement     OUT NOCOPY      VARCHAR2
   )
   IS
      l_api_name               VARCHAR2(240)
               := 'CHECK_SYNTAX';

Line: 135

      l_select_id              jtf_objects_b.select_id%TYPE
               := p_select_id;

Line: 137

      l_select_name            jtf_objects_b.select_name%TYPE
               := p_select_name;

Line: 139

      l_select_details         jtf_objects_b.select_details%TYPE
               := p_select_details;

Line: 149

      l_select_columns         NUMBER                             := 0;

Line: 150

      l_dummy_select_id        VARCHAR2(2000);

Line: 151

      l_dummy_select_name      VARCHAR2(2000);

Line: 152

      l_dummy_select_details   VARCHAR2(2000);

Line: 178

      IF l_select_id IS NOT NULL
      THEN
         x_sql_statement := ' select ' || l_select_id;

Line: 182

         l_select_columns := l_select_columns + 1;

Line: 185

      IF l_select_name IS NOT NULL
      THEN
         IF initialized = TRUE
         THEN
            x_sql_statement := x_sql_statement || ', ' || l_select_name;

Line: 191

            l_select_columns := l_select_columns + 1;

Line: 193

            x_sql_statement := ' select ' || l_select_name;

Line: 197

      IF l_select_details IS NOT NULL
      THEN
         IF initialized = TRUE
         THEN
            x_sql_statement := x_sql_statement || ', ' || l_select_details;

Line: 203

            l_select_columns := l_select_columns + 1;

Line: 205

            x_sql_statement := ' select ' || l_select_details;

Line: 211

         x_sql_statement := ' select 1 ';

Line: 244

         IF l_select_columns = 1
         THEN
            EXECUTE IMMEDIATE x_sql_statement
               INTO l_dummy_select_id;

Line: 250

         IF l_select_columns = 2
         THEN
            EXECUTE IMMEDIATE x_sql_statement
               INTO l_dummy_select_id, l_dummy_select_name;

Line: 256

         IF l_select_columns = 3
         THEN
            EXECUTE IMMEDIATE x_sql_statement
               INTO l_dummy_select_id, l_dummy_select_name, l_dummy_select_details;

Line: 296

     G_OBJECT_PG_TBL.DELETE;

Line: 312

     SELECT 1 AS OBJ_ROW_TYPE
          , JOPD.PG_REGION_PATH
          , JOPP.DEST_PARAM
          , JOPP.SOURCE_PARAM
     FROM   JTF_OBJECTS_B JOB
          , JTF_OBJECT_PG_DTLS JOPD
          , JTF_OBJECT_PG_PARAMS JOPP
     WHERE  JOB.OBJECT_CODE     = b_object_code
     AND    JOPD.OBJECT_CODE    = JOB.OBJECT_CODE
     AND    JOPD.APPLICATION_ID = b_application_id
     AND    JOPD.PAGE_TYPE      = 'OA_PAGE'
     AND    JOPP.OBJECT_DTLS_ID = JOPD.OBJECT_DTLS_ID
     UNION ALL
     SELECT 2 AS OBJ_ROW_TYPE
          , JOPD.PG_REGION_PATH
          , JOPP.DEST_PARAM
          , JOPP.SOURCE_PARAM
     FROM   JTF_OBJECTS_B JOB
          , JTF_OBJECT_PG_DTLS JOPD
          , JTF_OBJECT_PG_PARAMS JOPP
     WHERE  JOB.OBJECT_CODE     = b_default_object_code
     AND    JOPD.OBJECT_CODE    = JOB.OBJECT_CODE
     AND    JOPD.APPLICATION_ID = JOB.APPLICATION_ID
     AND    JOPD.PAGE_TYPE      = 'OA_PAGE'
     AND    JOPP.OBJECT_DTLS_ID = JOPD.OBJECT_DTLS_ID;