APPS.JTF_OBJECTS_PVT SQL Statements

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

Line: 33

  )IS SELECT select_id
      ,      select_name
      ,      select_details
      ,      from_table
      ,      where_clause
      FROM   jtf_objects_b
      WHERE  object_code = b_ObjectCode;

Line: 41

  CURSOR c_SelectIDType
  (b_table_name   IN VARCHAR2
  ,b_column_name  IN VARCHAR2
  ,p_oracle_schema IN VARCHAR2 )IS SELECT DISTINCT data_type
      FROM   all_tab_columns col, user_synonyms syn
      WHERE  syn.synonym_name = b_table_name
      AND    col.owner = syn.table_owner
      AND    col.table_name = syn.table_name
      AND    col.column_name = b_column_name;

Line: 51

  l_SelectID           VARCHAR2(200);

Line: 52

  l_SelectName         VARCHAR2(2000);

Line: 53

  l_SelectDetails      VARCHAR2(2000);

Line: 57

  l_SelectIDType       VARCHAR2(106);

Line: 71

    l_SelectID      := l_JTFObject.select_id;

Line: 72

    l_SelectName    := l_JTFObject.select_name;

Line: 73

    l_SelectDetails := l_JTFObject.select_details;

Line: 91

  ** Get the datatype of the select ID
  *****************************************************************************/
  FOR r_SelectIDType IN c_SelectIDType(UPPER(l_FromTable)
                                      ,UPPER(l_SelectID)
                                      ,l_oracle_schema)
  LOOP
    l_SelectIDType := r_SelectIDType.data_type;

Line: 103

  IF (l_SelectIDType = 'NUMBER')
  THEN
    l_Query := 'SELECT '||l_SelectName ||
               ' FROM '||l_FromTable;

Line: 111

                           ' AND '||l_SelectID||' = :1';

Line: 113

      l_Query := l_Query||' WHERE ' ||l_SelectID||' = :1';

Line: 117

    l_Query := 'SELECT '||l_SelectName ||
               ' FROM '||l_FromTable;

Line: 123

                           ' AND '||l_SelectID||' = :1';

Line: 125

      l_Query := l_Query ||' WHERE ' ||l_SelectID||' = :1';