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

Line 2159: g_cursor INT DEFAULT dbms_sql.open_cursor;

2155: l_num_col_num NUMBER := 0;
2156: l_other_col_num NUMBER := 0;
2157: l_total_col_count NUMBER := 0;
2158: l_comma VARCHAR2(1) := '';
2159: g_cursor INT DEFAULT dbms_sql.open_cursor;
2160: l_status integer;
2161:
2162: BEGIN
2163:

Line 2264: dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1

2260: END LOOP;
2261:
2262: l_value_clause := l_value_clause || ')';
2263:
2264: dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1
2265: || l_value_clause, dbms_sql.native);
2266:
2267: FOR i IN 1 .. p_row_count
2268:

Line 2265: || l_value_clause, dbms_sql.native);

2261:
2262: l_value_clause := l_value_clause || ')';
2263:
2264: dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1
2265: || l_value_clause, dbms_sql.native);
2266:
2267: FOR i IN 1 .. p_row_count
2268:
2269: LOOP

Line 2277: --dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1

2273: --ELSE
2274: -- l_load_status := L_ERROR;
2275: --END IF;
2276:
2277: --dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1
2278: -- || l_value_clause, dbms_sql.native);
2279:
2280: --primary_key
2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));

Line 2278: -- || l_value_clause, dbms_sql.native);

2274: -- l_load_status := L_ERROR;
2275: --END IF;
2276:
2277: --dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1
2278: -- || l_value_clause, dbms_sql.native);
2279:
2280: --primary_key
2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));
2282: --LAST_UPDATE_DATE

Line 2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));

2277: --dbms_sql.parse (g_cursor, l_tab_name_clause1 || l_col_clause1
2278: -- || l_value_clause, dbms_sql.native);
2279:
2280: --primary_key
2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));
2282: --LAST_UPDATE_DATE
2283: dbms_sql.bind_variable (g_cursor, ':r2', l_date);
2284: --LAST_UPDATED_BY
2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);

Line 2283: dbms_sql.bind_variable (g_cursor, ':r2', l_date);

2279:
2280: --primary_key
2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));
2282: --LAST_UPDATE_DATE
2283: dbms_sql.bind_variable (g_cursor, ':r2', l_date);
2284: --LAST_UPDATED_BY
2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);
2286: --CREATION_DATE
2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);

Line 2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);

2281: dbms_sql.bind_variable (g_cursor, ':r1', l_source_line_keys(i));
2282: --LAST_UPDATE_DATE
2283: dbms_sql.bind_variable (g_cursor, ':r2', l_date);
2284: --LAST_UPDATED_BY
2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);
2286: --CREATION_DATE
2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);
2288: --CREATED_BY
2289: dbms_sql.bind_variable (g_cursor, ':r5', l_user_id);

Line 2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);

2283: dbms_sql.bind_variable (g_cursor, ':r2', l_date);
2284: --LAST_UPDATED_BY
2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);
2286: --CREATION_DATE
2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);
2288: --CREATED_BY
2289: dbms_sql.bind_variable (g_cursor, ':r5', l_user_id);
2290: --LAST_UPDATE_LOGIN
2291: dbms_sql.bind_variable (g_cursor, ':r6', l_login_id);

Line 2289: dbms_sql.bind_variable (g_cursor, ':r5', l_user_id);

2285: dbms_sql.bind_variable (g_cursor, ':r3', l_user_id);
2286: --CREATION_DATE
2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);
2288: --CREATED_BY
2289: dbms_sql.bind_variable (g_cursor, ':r5', l_user_id);
2290: --LAST_UPDATE_LOGIN
2291: dbms_sql.bind_variable (g_cursor, ':r6', l_login_id);
2292:
2293: --string data

Line 2291: dbms_sql.bind_variable (g_cursor, ':r6', l_login_id);

2287: dbms_sql.bind_variable (g_cursor, ':r4', l_date);
2288: --CREATED_BY
2289: dbms_sql.bind_variable (g_cursor, ':r5', l_user_id);
2290: --LAST_UPDATE_LOGIN
2291: dbms_sql.bind_variable (g_cursor, ':r6', l_login_id);
2292:
2293: --string data
2294: FOR j IN 1 .. l_varchar_col_num
2295: LOOP

Line 2296: dbms_sql.bind_variable (g_cursor, ':v' || j, p_str_data(j));

2292:
2293: --string data
2294: FOR j IN 1 .. l_varchar_col_num
2295: LOOP
2296: dbms_sql.bind_variable (g_cursor, ':v' || j, p_str_data(j));
2297: END LOOP;
2298:
2299: --num data
2300: FOR k IN 1 .. l_num_col_num

Line 2302: dbms_sql.bind_variable (g_cursor, ':n' || k, p_num_data(k));

2298:
2299: --num data
2300: FOR k IN 1 .. l_num_col_num
2301: LOOP
2302: dbms_sql.bind_variable (g_cursor, ':n' || k, p_num_data(k));
2303: END LOOP;
2304:
2305: --other data
2306: FOR l IN 1 .. l_other_col_num -1

Line 2308: dbms_sql.bind_variable (g_cursor, ':o' || l,

2304:
2305: --other data
2306: FOR l IN 1 .. l_other_col_num -1
2307: LOOP
2308: dbms_sql.bind_variable (g_cursor, ':o' || l,
2309: RTRIM(LTRIM(p_data (i + (l - 1) * p_row_count))));
2310: END LOOP;
2311:
2312: --status_code

Line 2313: dbms_sql.bind_variable (g_cursor, ':o' || l_other_col_num,

2309: RTRIM(LTRIM(p_data (i + (l - 1) * p_row_count))));
2310: END LOOP;
2311:
2312: --status_code
2313: dbms_sql.bind_variable (g_cursor, ':o' || l_other_col_num,
2314: l_load_status);
2315:
2316: l_status := dbms_sql.EXECUTE(g_cursor);
2317:

Line 2316: l_status := dbms_sql.EXECUTE(g_cursor);

2312: --status_code
2313: dbms_sql.bind_variable (g_cursor, ':o' || l_other_col_num,
2314: l_load_status);
2315:
2316: l_status := dbms_sql.EXECUTE(g_cursor);
2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: dbms_sql.close_cursor (g_cursor);

Line 2320: dbms_sql.close_cursor (g_cursor);

2316: l_status := dbms_sql.EXECUTE(g_cursor);
2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: dbms_sql.close_cursor (g_cursor);
2321: x_msg_data := 'Error at row ' || i || ' ' || SQLERRM;
2322: x_msg_data := x_msg_data || ' If you mapped the "party_id" , it should be a number.';
2323: RAISE FND_API.G_EXC_ERROR;
2324: END;

Line 2326: dbms_sql.close_cursor (g_cursor);

2322: x_msg_data := x_msg_data || ' If you mapped the "party_id" , it should be a number.';
2323: RAISE FND_API.G_EXC_ERROR;
2324: END;
2325: END LOOP;
2326: dbms_sql.close_cursor (g_cursor);
2327:
2328:
2329: --FOR j IN p_error_rows.FIRST .. p_error_rows.LAST
2330: --LOOP