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.FV_GTAS_INTERFACE dependencies on DBMS_SQL

Line 1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;

1242: Where Set_Of_Books_Id = Gbl_Set_Of_Books_Id;
1243:
1244: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||
1245: ' from gl_code_combinations where code_combination_id=' || p_ccid;
1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;

Line 1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);

1243:
1244: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||
1245: ' from gl_code_combinations where code_combination_id=' || p_ccid;
1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);

Line 1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);

1244: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||
1245: ' from gl_code_combinations where code_combination_id=' || p_ccid;
1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);
1252: dbms_sql.close_cursor(Vl_Cursor);

Line 1249: I:= Dbms_Sql.Execute(vl_cursor);

1245: ' from gl_code_combinations where code_combination_id=' || p_ccid;
1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);
1252: dbms_sql.close_cursor(Vl_Cursor);
1253: end if;

Line 1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;

1246: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);
1252: dbms_sql.close_cursor(Vl_Cursor);
1253: end if;
1254: Exception

Line 1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);

1247: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);
1252: dbms_sql.close_cursor(Vl_Cursor);
1253: end if;
1254: Exception
1255: When Others Then

Line 1252: dbms_sql.close_cursor(Vl_Cursor);

1248: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1249: I:= Dbms_Sql.Execute(vl_cursor);
1250: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1251: Dbms_Sql.Column_Value(Vl_Cursor, 1, p_CREDIT_COHORT_YR);
1252: dbms_sql.close_cursor(Vl_Cursor);
1253: end if;
1254: Exception
1255: When Others Then
1256: Null;