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

Line 3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

3182: -- bug#3426783.
3183: -- added to strip _OA on the fly, if the page name has been migrated
3184: IF(p_object_type = 'PAGE') THEN
3185: l_stmt := 'BEGIN :function_name := bis_impl_dev_pkg.get_function_by_page(:page_name); END;';
3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);

Line 3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

3183: -- added to strip _OA on the fly, if the page name has been migrated
3184: IF(p_object_type = 'PAGE') THEN
3185: l_stmt := 'BEGIN :function_name := bis_impl_dev_pkg.get_function_by_page(:page_name); END;';
3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);

Line 3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);

3184: IF(p_object_type = 'PAGE') THEN
3185: l_stmt := 'BEGIN :function_name := bis_impl_dev_pkg.get_function_by_page(:page_name); END;';
3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);

Line 3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);

3185: l_stmt := 'BEGIN :function_name := bis_impl_dev_pkg.get_function_by_page(:page_name); END;';
3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);

Line 3190: l_rows:=DBMS_SQL.execute(l_cursor_id);

3186: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:

Line 3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);

3187: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

Line 3192: DBMS_SQL.close_cursor(l_cursor_id);

3188: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3189: DBMS_SQL.bind_variable(l_cursor_id,'function_name',l_func1, 300);
3190: l_rows:=DBMS_SQL.execute(l_cursor_id);
3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

Line 3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

3191: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func1);
3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);

Line 3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

3192: DBMS_SQL.close_cursor(l_cursor_id);
3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);

Line 3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);

3193: log(l_module, 'Function name for ' || p_object_name || ' : ' || l_func1);
3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);
3201: DBMS_SQL.close_cursor(l_cursor_id);

Line 3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);

3194:
3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);
3201: DBMS_SQL.close_cursor(l_cursor_id);
3202: log(l_module, 'Function name for ' || p_object_name || '_OA' || ' : ' || l_func2);

Line 3199: l_rows:=DBMS_SQL.execute(l_cursor_id);

3195: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);
3201: DBMS_SQL.close_cursor(l_cursor_id);
3202: log(l_module, 'Function name for ' || p_object_name || '_OA' || ' : ' || l_func2);
3203:

Line 3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);

3196: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);
3201: DBMS_SQL.close_cursor(l_cursor_id);
3202: log(l_module, 'Function name for ' || p_object_name || '_OA' || ' : ' || l_func2);
3203:
3204: IF( p_object_name = l_func1 AND

Line 3201: DBMS_SQL.close_cursor(l_cursor_id);

3197: DBMS_SQL.bind_variable(l_cursor_id,'page_name',p_object_name, 300);
3198: DBMS_SQL.bind_variable(l_cursor_id,'function_name', l_func2 || '_OA', 300);
3199: l_rows:=DBMS_SQL.execute(l_cursor_id);
3200: DBMS_SQL.variable_value(l_cursor_id,'function_name',l_func2);
3201: DBMS_SQL.close_cursor(l_cursor_id);
3202: log(l_module, 'Function name for ' || p_object_name || '_OA' || ' : ' || l_func2);
3203:
3204: IF( p_object_name = l_func1 AND
3205: l_func1 = l_func2 ) THEN

Line 3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);

Line 3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);

Line 3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);

3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:

Line 3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);

3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

Line 3717: l_rows:=DBMS_SQL.execute(l_cursor_id);

3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

Line 3718: DBMS_SQL.close_cursor(l_cursor_id);

3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3722: