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

Line 2830: v_select INTEGER; /* "Pointer" to a DBMS_SQL select statement */

2826: requester_id NUMBER;
2827:
2828: /*Bug 16772090*/
2829: v_SQL varchar2(2000);
2830: v_select INTEGER; /* "Pointer" to a DBMS_SQL select statement */
2831: v_execute INTEGER;
2832: v_column NUMBER;
2833: row_count INTEGER;
2834: l_curr_calling_sequence VARCHAR2(100);

Line 2859: v_select := dbms_sql.open_cursor;

2855: v_SQL := v_SQL || ' AND upper(email_address) = :p_email_address';
2856: END IF;
2857:
2858: -- Setup Cursor
2859: v_select := dbms_sql.open_cursor;
2860: dbms_sql.parse( v_select, v_SQL, DBMS_SQL.native);
2861:
2862: IF p_first_name IS NOT NULL THEN
2863: dbms_sql.bind_variable( v_select, ':p_first_name', upper(p_first_name) );

Line 2860: dbms_sql.parse( v_select, v_SQL, DBMS_SQL.native);

2856: END IF;
2857:
2858: -- Setup Cursor
2859: v_select := dbms_sql.open_cursor;
2860: dbms_sql.parse( v_select, v_SQL, DBMS_SQL.native);
2861:
2862: IF p_first_name IS NOT NULL THEN
2863: dbms_sql.bind_variable( v_select, ':p_first_name', upper(p_first_name) );
2864: END IF;

Line 2863: dbms_sql.bind_variable( v_select, ':p_first_name', upper(p_first_name) );

2859: v_select := dbms_sql.open_cursor;
2860: dbms_sql.parse( v_select, v_SQL, DBMS_SQL.native);
2861:
2862: IF p_first_name IS NOT NULL THEN
2863: dbms_sql.bind_variable( v_select, ':p_first_name', upper(p_first_name) );
2864: END IF;
2865:
2866: IF p_last_name IS NOT NULL THEN
2867: dbms_sql.bind_variable( v_select, ':p_last_name', upper(p_last_name) );

Line 2867: dbms_sql.bind_variable( v_select, ':p_last_name', upper(p_last_name) );

2863: dbms_sql.bind_variable( v_select, ':p_first_name', upper(p_first_name) );
2864: END IF;
2865:
2866: IF p_last_name IS NOT NULL THEN
2867: dbms_sql.bind_variable( v_select, ':p_last_name', upper(p_last_name) );
2868: END IF;
2869:
2870: IF p_email_address IS NOT NULL THEN
2871: dbms_sql.bind_variable( v_select, ':p_email_address', upper(p_email_address) );

Line 2871: dbms_sql.bind_variable( v_select, ':p_email_address', upper(p_email_address) );

2867: dbms_sql.bind_variable( v_select, ':p_last_name', upper(p_last_name) );
2868: END IF;
2869:
2870: IF p_email_address IS NOT NULL THEN
2871: dbms_sql.bind_variable( v_select, ':p_email_address', upper(p_email_address) );
2872: END IF;
2873:
2874: DBMS_SQL.DEFINE_COLUMN(v_select, 1, v_column);
2875:

Line 2874: DBMS_SQL.DEFINE_COLUMN(v_select, 1, v_column);

2870: IF p_email_address IS NOT NULL THEN
2871: dbms_sql.bind_variable( v_select, ':p_email_address', upper(p_email_address) );
2872: END IF;
2873:
2874: DBMS_SQL.DEFINE_COLUMN(v_select, 1, v_column);
2875:
2876: v_execute := DBMS_SQL.EXECUTE( v_select );
2877:
2878: row_count := 0;

Line 2876: v_execute := DBMS_SQL.EXECUTE( v_select );

2872: END IF;
2873:
2874: DBMS_SQL.DEFINE_COLUMN(v_select, 1, v_column);
2875:
2876: v_execute := DBMS_SQL.EXECUTE( v_select );
2877:
2878: row_count := 0;
2879: l_debug_info := 'query to fetch person id by passing first, last name or email address';
2880: LOOP

Line 2881: IF DBMS_SQL.FETCH_ROWS(v_select) = 0 THEN

2877:
2878: row_count := 0;
2879: l_debug_info := 'query to fetch person id by passing first, last name or email address';
2880: LOOP
2881: IF DBMS_SQL.FETCH_ROWS(v_select) = 0 THEN
2882: EXIT;
2883: END IF;
2884: DBMS_SQL.COLUMN_VALUE( v_select, 1, v_column);
2885: row_count := DBMS_SQL.LAST_ROW_COUNT;

Line 2884: DBMS_SQL.COLUMN_VALUE( v_select, 1, v_column);

2880: LOOP
2881: IF DBMS_SQL.FETCH_ROWS(v_select) = 0 THEN
2882: EXIT;
2883: END IF;
2884: DBMS_SQL.COLUMN_VALUE( v_select, 1, v_column);
2885: row_count := DBMS_SQL.LAST_ROW_COUNT;
2886:
2887: IF row_count > 1 THEN
2888: EXIT;

Line 2885: row_count := DBMS_SQL.LAST_ROW_COUNT;

2881: IF DBMS_SQL.FETCH_ROWS(v_select) = 0 THEN
2882: EXIT;
2883: END IF;
2884: DBMS_SQL.COLUMN_VALUE( v_select, 1, v_column);
2885: row_count := DBMS_SQL.LAST_ROW_COUNT;
2886:
2887: IF row_count > 1 THEN
2888: EXIT;
2889: END IF;

Line 2904: DBMS_SQL.CLOSE_CURSOR(v_select);

2900: p_requester_id := NULL;
2901: END IF;
2902:
2903: --Tidy Up
2904: DBMS_SQL.CLOSE_CURSOR(v_select);
2905:
2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: IF DBMS_SQL.IS_open(v_select) THEN

Line 2908: IF DBMS_SQL.IS_open(v_select) THEN

2904: DBMS_SQL.CLOSE_CURSOR(v_select);
2905:
2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: IF DBMS_SQL.IS_open(v_select) THEN
2909: p_requester_id := NULL;
2910: DBMS_SQL.CLOSE_CURSOR(v_select);
2911: END IF;
2912: IF (SQLCODE <> -20001) THEN

Line 2910: DBMS_SQL.CLOSE_CURSOR(v_select);

2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: IF DBMS_SQL.IS_open(v_select) THEN
2909: p_requester_id := NULL;
2910: DBMS_SQL.CLOSE_CURSOR(v_select);
2911: END IF;
2912: IF (SQLCODE <> -20001) THEN
2913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);