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

Line 1617: lv_cur := DBMS_SQL.OPEN_CURSOR;

1613: lv_column_name := rec_ISIR_corr.column_name;
1614: lv_column_meaning := rec_ISIR_corr.meaning;
1615: ln_isir_id := TO_CHAR (p_isir_id) ;
1616:
1617: lv_cur := DBMS_SQL.OPEN_CURSOR;
1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;
1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:

Line 1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);

1615: ln_isir_id := TO_CHAR (p_isir_id) ;
1616:
1617: lv_cur := DBMS_SQL.OPEN_CURSOR;
1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;
1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);

Line 1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);

1616:
1617: lv_cur := DBMS_SQL.OPEN_CURSOR;
1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;
1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);

Line 1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);

1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;
1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1625: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1626:

Line 1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);

1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1625: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1626:
1627: --

Line 1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);

1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1625: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1626:
1627: --
1628: -- Compare the values and if the value send for correction is same as the value present in the ISIR then

Line 1625: DBMS_SQL.CLOSE_CURSOR(lv_cur);

1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1623: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1624: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1625: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1626:
1627: --
1628: -- Compare the values and if the value send for correction is same as the value present in the ISIR then
1629: -- Mark the record as ACKNOWLEDGED.