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

Line 2029: l_rec_tab DBMS_SQL.desc_tab;

2025: l_exec NUMBER;
2026: l_error BOOLEAN;
2027:
2028: l_col_tbl rec_cols_tbl;
2029: l_rec_tab DBMS_SQL.desc_tab;
2030: l_att_names_tbl varchar_tbl_type;
2031: l_db_columns_tbl varchar_tbl_type;
2032: l_num_value_tbl number_tbl_type;
2033:

Line 2416: l_cursor := DBMS_SQL.OPEN_CURSOR;

2412: 'WHERE apcpropvals.item_catalog_group_id = itemtypes.item_catalog_group_id AND inventory_item_id IS NOT NULL ORDER BY INVENTORY_ITEM_ID';
2413: --
2414: -- define cursor and dynamically describe columns of this cursor
2415: --
2416: l_cursor := DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2418: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2419: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2420:

Line 2417: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);

2413: --
2414: -- define cursor and dynamically describe columns of this cursor
2415: --
2416: l_cursor := DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2418: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2419: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2420:
2421: --

Line 2418: l_exec := DBMS_SQL.EXECUTE(l_cursor);

2414: -- define cursor and dynamically describe columns of this cursor
2415: --
2416: l_cursor := DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2418: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2419: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2420:
2421: --
2422: -- dynamically define columns of record set

Line 2419: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);

2415: --
2416: l_cursor := DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2418: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2419: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2420:
2421: --
2422: -- dynamically define columns of record set
2423: --

Line 2434: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);

2430: l_col_tbl(l_col_name).col_name := l_col_name;
2431: l_col_tbl(l_col_name).col_num := l_col_num;
2432:
2433: IF l_col_name IN('ATTR_GROUP_ID') THEN
2434: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2435: l_attr_group_col_num := l_col_num;
2436: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2437: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2438: l_inv_item_col_num := l_col_num;

Line 2437: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);

2433: IF l_col_name IN('ATTR_GROUP_ID') THEN
2434: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2435: l_attr_group_col_num := l_col_num;
2436: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2437: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2438: l_inv_item_col_num := l_col_num;
2439: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2440: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2441: l_org_id_col_num := l_col_num;

Line 2440: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);

2436: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2437: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2438: l_inv_item_col_num := l_col_num;
2439: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2440: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2441: l_org_id_col_num := l_col_num;
2442: ELSIF l_col_name IN('LANGUAGE') THEN
2443: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2444: l_lang_col_num := l_col_num;

Line 2443: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);

2439: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2440: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2441: l_org_id_col_num := l_col_num;
2442: ELSIF l_col_name IN('LANGUAGE') THEN
2443: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2444: l_lang_col_num := l_col_num;
2445: ELSIF l_col_name IN('SOURCE_LANG') THEN
2446: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2447: l_source_lang_col_num := l_col_num;

Line 2446: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);

2442: ELSIF l_col_name IN('LANGUAGE') THEN
2443: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2444: l_lang_col_num := l_col_num;
2445: ELSIF l_col_name IN('SOURCE_LANG') THEN
2446: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2447: l_source_lang_col_num := l_col_num;
2448: END IF;
2449:
2450: IF l_used_db_columns_tbl.EXISTS(l_col_name) THEN

Line 2451: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);

2447: l_source_lang_col_num := l_col_num;
2448: END IF;
2449:
2450: IF l_used_db_columns_tbl.EXISTS(l_col_name) THEN
2451: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2452: END IF;
2453:
2454: l_col_num := l_rec_tab.NEXT(l_col_num);
2455: EXIT WHEN (l_col_num IS NULL);

Line 2469: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN

2465: -- fetch records from dynamic cursor with sql = l_sql
2466: --
2467: LOOP
2468:
2469: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2470: EXIT;
2471: ELSE
2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);

Line 2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);

2468:
2469: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2470: EXIT;
2471: ELSE
2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);

Line 2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);

2469: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2470: EXIT;
2471: ELSE
2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2477:

Line 2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);

2470: EXIT;
2471: ELSE
2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2477:
2478: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);

Line 2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);

2471: ELSE
2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2477:
2478: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);
2479: l_db_columns_tbl := l_group_database_columns_tbl(l_attr_group_id);

Line 2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);

2472: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2473: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2474: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2475: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2476: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2477:
2478: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);
2479: l_db_columns_tbl := l_group_database_columns_tbl(l_attr_group_id);
2480: l_db_column_types_tbl := l_group_db_column_types_tbl(l_attr_group_id);

Line 2493: DBMS_SQL.COLUMN_VALUE(l_cursor,l_column_num,l_column_value);

2489:
2490: --
2491: -- find value of property which is stored in column l_db_columns_tbl(n)
2492: --
2493: DBMS_SQL.COLUMN_VALUE(l_cursor,l_column_num,l_column_value);
2494:
2495: IF l_column_value IS NOT NULL THEN
2496:
2497: l_rec_counter := l_rec_counter + 1;

Line 2529: END IF; -- end of IF DBMS_SQL.FETCH_ROWS(l_cursor)=0

2525: END IF;
2526:
2527: END LOOP; -- end of FOR n IN ...
2528:
2529: END IF; -- end of IF DBMS_SQL.FETCH_ROWS(l_cursor)=0
2530:
2531: IF l_prop_values_tbl.COUNT > 0 AND (l_rec_counter=l_Batch_Size OR FLOOR(l_rec_counter/l_Batch_Size)=0) THEN
2532:
2533: --

Line 2579: DBMS_SQL.CLOSE_CURSOR(l_cursor);

2575:
2576: END LOOP; -- end of looping through l_cursor
2577:
2578: -- close cursor
2579: DBMS_SQL.CLOSE_CURSOR(l_cursor);
2580:
2581: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2582: COMMIT;
2583: