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_BATCH_VER_PRC_PKG dependencies on DBMS_SQL

Line 80: |The initialization of cursor variable dbms_sql.open_cursor removed from|

76: | Added x_pell_alt_expense in igf_ap_fa_base_rec_pkg |
77: | Modified get_gr_ver_code to read mapping from igf_aw_int_ext_map table|
78: |-----------------------------------------------------------------------|
79: | 12-Jun-2002 Bug ID: 2402371/ 2403886. |
80: |The initialization of cursor variable dbms_sql.open_cursor removed from|
81: |declaration section and moved to main body as it was failing when more |
82: |cursor was required to be open more than once. |
83: |EXECUTE IMMEDIATE Directly used instead of DBMS_SQL |
84: | Bug ID : 1818617 |

Line 83: |EXECUTE IMMEDIATE Directly used instead of DBMS_SQL |

79: | 12-Jun-2002 Bug ID: 2402371/ 2403886. |
80: |The initialization of cursor variable dbms_sql.open_cursor removed from|
81: |declaration section and moved to main body as it was failing when more |
82: |cursor was required to be open more than once. |
83: |EXECUTE IMMEDIATE Directly used instead of DBMS_SQL |
84: | Bug ID : 1818617 |
85: | who when what |
86: |-----------------------------------------------------------------------
87: | bkkumar 02-July-2003 Bug 3004841 |

Line 1345: lv_cur := DBMS_SQL.OPEN_CURSOR;

1341: END IF;
1342: ELSE
1343:
1344: IF pv_column_name IS NOT NULL THEN
1345: lv_cur := DBMS_SQL.OPEN_CURSOR;
1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);
1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);

Line 1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);

1344: IF pv_column_name IS NOT NULL THEN
1345: lv_cur := DBMS_SQL.OPEN_CURSOR;
1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);
1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1351: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);

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

1345: lv_cur := DBMS_SQL.OPEN_CURSOR;
1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);
1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1351: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1353: END IF;

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

1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);
1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1351: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1353: END IF;
1354:

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

1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1351: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1353: END IF;
1354:
1355: -- Processing for String Values.

Line 1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);

1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);
1351: DBMS_SQL.COLUMN_VALUE(lv_cur,1,lv_retval);
1352: DBMS_SQL.CLOSE_CURSOR(lv_cur);
1353: END IF;
1354:
1355: -- Processing for String Values.
1356: IF UPPER(LTRIM(RTRIM(NVL(lv_retval,'#')))) <> UPPER(LTRIM(RTRIM(NVL(lv_item_value,'#')))) THEN