eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_DEFAS_ACCESS_DETAILS_PKG dependencies on DBMS_SQL

Line 124: c := dbms_sql.open_cursor;

120: X_Table_Name => table_name,
121: X_Where_Clause => where_clause);
122: query_stat := 'SELECT '||name_column||' FROM '||table_name||
123: ' WHERE '||id_column||'= :1';
124: c := dbms_sql.open_cursor;
125: dbms_sql.parse(c,query_stat,dbms_sql.native);
126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);

Line 125: dbms_sql.parse(c,query_stat,dbms_sql.native);

121: X_Where_Clause => where_clause);
122: query_stat := 'SELECT '||name_column||' FROM '||table_name||
123: ' WHERE '||id_column||'= :1';
124: c := dbms_sql.open_cursor;
125: dbms_sql.parse(c,query_stat,dbms_sql.native);
126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP

Line 126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );

122: query_stat := 'SELECT '||name_column||' FROM '||table_name||
123: ' WHERE '||id_column||'= :1';
124: c := dbms_sql.open_cursor;
125: dbms_sql.parse(c,query_stat,dbms_sql.native);
126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP
130: IF(dbms_sql.fetch_rows(c)>0)THEN

Line 127: dbms_sql.define_column(c,1,name_val,30);

123: ' WHERE '||id_column||'= :1';
124: c := dbms_sql.open_cursor;
125: dbms_sql.parse(c,query_stat,dbms_sql.native);
126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP
130: IF(dbms_sql.fetch_rows(c)>0)THEN
131: dbms_sql.column_value(c,1,name_val);

Line 128: ignore := dbms_sql.execute(c);

124: c := dbms_sql.open_cursor;
125: dbms_sql.parse(c,query_stat,dbms_sql.native);
126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP
130: IF(dbms_sql.fetch_rows(c)>0)THEN
131: dbms_sql.column_value(c,1,name_val);
132: object_name := name_val;

Line 130: IF(dbms_sql.fetch_rows(c)>0)THEN

126: dbms_sql.bind_variable(c, ':1', X_Obj_Key );
127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP
130: IF(dbms_sql.fetch_rows(c)>0)THEN
131: dbms_sql.column_value(c,1,name_val);
132: object_name := name_val;
133: ELSE
134: EXIT;

Line 131: dbms_sql.column_value(c,1,name_val);

127: dbms_sql.define_column(c,1,name_val,30);
128: ignore := dbms_sql.execute(c);
129: LOOP
130: IF(dbms_sql.fetch_rows(c)>0)THEN
131: dbms_sql.column_value(c,1,name_val);
132: object_name := name_val;
133: ELSE
134: EXIT;
135: END IF;

Line 163: c := dbms_sql.open_cursor;

159: X_Table_Name => table_name,
160: X_Where_Clause => where_clause);
161: query_stat := 'SELECT '||id_column||' FROM '||table_name||
162: ' WHERE '||name_column||'= :1';
163: c := dbms_sql.open_cursor;
164: dbms_sql.parse(c,query_stat,dbms_sql.native);
165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);

Line 164: dbms_sql.parse(c,query_stat,dbms_sql.native);

160: X_Where_Clause => where_clause);
161: query_stat := 'SELECT '||id_column||' FROM '||table_name||
162: ' WHERE '||name_column||'= :1';
163: c := dbms_sql.open_cursor;
164: dbms_sql.parse(c,query_stat,dbms_sql.native);
165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP

Line 165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);

161: query_stat := 'SELECT '||id_column||' FROM '||table_name||
162: ' WHERE '||name_column||'= :1';
163: c := dbms_sql.open_cursor;
164: dbms_sql.parse(c,query_stat,dbms_sql.native);
165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP
169: IF(dbms_sql.fetch_rows(c)>0)THEN

Line 166: dbms_sql.define_column(c,1,name_val,30);

162: ' WHERE '||name_column||'= :1';
163: c := dbms_sql.open_cursor;
164: dbms_sql.parse(c,query_stat,dbms_sql.native);
165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP
169: IF(dbms_sql.fetch_rows(c)>0)THEN
170: dbms_sql.column_value(c,1,name_val);

Line 167: ignore := dbms_sql.execute(c);

163: c := dbms_sql.open_cursor;
164: dbms_sql.parse(c,query_stat,dbms_sql.native);
165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP
169: IF(dbms_sql.fetch_rows(c)>0)THEN
170: dbms_sql.column_value(c,1,name_val);
171: object_key := name_val;

Line 169: IF(dbms_sql.fetch_rows(c)>0)THEN

165: dbms_sql.bind_variable(c, ':1', X_Obj_Name);
166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP
169: IF(dbms_sql.fetch_rows(c)>0)THEN
170: dbms_sql.column_value(c,1,name_val);
171: object_key := name_val;
172: ELSE
173: EXIT;

Line 170: dbms_sql.column_value(c,1,name_val);

166: dbms_sql.define_column(c,1,name_val,30);
167: ignore := dbms_sql.execute(c);
168: LOOP
169: IF(dbms_sql.fetch_rows(c)>0)THEN
170: dbms_sql.column_value(c,1,name_val);
171: object_key := name_val;
172: ELSE
173: EXIT;
174: END IF;

Line 210: c := dbms_sql.open_cursor;

206: X_Table_Name => table_name,
207: X_Where_Clause => where_clause);
208: query_stat := 'SELECT security_flag FROM '||table_name||
209: ' WHERE to_char('||id_column||')= :1';
210: c := dbms_sql.open_cursor;
211: dbms_sql.parse(c,query_stat,dbms_sql.native);
212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);

Line 211: dbms_sql.parse(c,query_stat,dbms_sql.native);

207: X_Where_Clause => where_clause);
208: query_stat := 'SELECT security_flag FROM '||table_name||
209: ' WHERE to_char('||id_column||')= :1';
210: c := dbms_sql.open_cursor;
211: dbms_sql.parse(c,query_stat,dbms_sql.native);
212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP

Line 212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);

208: query_stat := 'SELECT security_flag FROM '||table_name||
209: ' WHERE to_char('||id_column||')= :1';
210: c := dbms_sql.open_cursor;
211: dbms_sql.parse(c,query_stat,dbms_sql.native);
212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP
216: IF(dbms_sql.fetch_rows(c)>0)THEN

Line 213: dbms_sql.define_column(c,1,securityFlag,1);

209: ' WHERE to_char('||id_column||')= :1';
210: c := dbms_sql.open_cursor;
211: dbms_sql.parse(c,query_stat,dbms_sql.native);
212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP
216: IF(dbms_sql.fetch_rows(c)>0)THEN
217: dbms_sql.column_value(c,1,securityFlag);

Line 214: ignore := dbms_sql.execute(c);

210: c := dbms_sql.open_cursor;
211: dbms_sql.parse(c,query_stat,dbms_sql.native);
212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP
216: IF(dbms_sql.fetch_rows(c)>0)THEN
217: dbms_sql.column_value(c,1,securityFlag);
218: ELSE

Line 216: IF(dbms_sql.fetch_rows(c)>0)THEN

212: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP
216: IF(dbms_sql.fetch_rows(c)>0)THEN
217: dbms_sql.column_value(c,1,securityFlag);
218: ELSE
219: EXIT;
220: END IF;

Line 217: dbms_sql.column_value(c,1,securityFlag);

213: dbms_sql.define_column(c,1,securityFlag,1);
214: ignore := dbms_sql.execute(c);
215: LOOP
216: IF(dbms_sql.fetch_rows(c)>0)THEN
217: dbms_sql.column_value(c,1,securityFlag);
218: ELSE
219: EXIT;
220: END IF;
221: END LOOP;

Line 228: c := dbms_sql.open_cursor;

224: llogin_id := FND_GLOBAL.Login_Id;
225: IF(securityFlag = 'N') THEN
226: update_stat := 'UPDATE '||table_name||' SET security_flag = ''Y'''||
227: ' WHERE to_char('||id_column||')= :1';
228: c := dbms_sql.open_cursor;
229: dbms_sql.parse(c,update_stat,dbms_sql.native);
230: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
231: ignore := dbms_sql.execute(c);
232:

Line 229: dbms_sql.parse(c,update_stat,dbms_sql.native);

225: IF(securityFlag = 'N') THEN
226: update_stat := 'UPDATE '||table_name||' SET security_flag = ''Y'''||
227: ' WHERE to_char('||id_column||')= :1';
228: c := dbms_sql.open_cursor;
229: dbms_sql.parse(c,update_stat,dbms_sql.native);
230: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
231: ignore := dbms_sql.execute(c);
232:
233: OPEN super_defas;

Line 230: dbms_sql.bind_variable(c, ':1', X_Obj_Key);

226: update_stat := 'UPDATE '||table_name||' SET security_flag = ''Y'''||
227: ' WHERE to_char('||id_column||')= :1';
228: c := dbms_sql.open_cursor;
229: dbms_sql.parse(c,update_stat,dbms_sql.native);
230: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
231: ignore := dbms_sql.execute(c);
232:
233: OPEN super_defas;
234: FETCH super_defas INTO defasId;

Line 231: ignore := dbms_sql.execute(c);

227: ' WHERE to_char('||id_column||')= :1';
228: c := dbms_sql.open_cursor;
229: dbms_sql.parse(c,update_stat,dbms_sql.native);
230: dbms_sql.bind_variable(c, ':1', X_Obj_Key);
231: ignore := dbms_sql.execute(c);
232:
233: OPEN super_defas;
234: FETCH super_defas INTO defasId;
235: if (super_defas%NOTFOUND) then