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 2091: l_rec_tab DBMS_SQL.desc_tab;

2087: l_exec NUMBER;
2088: l_error BOOLEAN;
2089:
2090: l_col_tbl rec_cols_tbl;
2091: l_rec_tab DBMS_SQL.desc_tab;
2092: l_att_names_tbl varchar_tbl_type;
2093: l_db_columns_tbl varchar_tbl_type;
2094: l_num_value_tbl number_tbl_type;
2095:

Line 2486: l_cursor := DBMS_SQL.OPEN_CURSOR;

2482: ' AND inventory_item_id IS NOT NULL ORDER BY INVENTORY_ITEM_ID';
2483: --
2484: -- define cursor and dynamically describe columns of this cursor
2485: --
2486: l_cursor := DBMS_SQL.OPEN_CURSOR;
2487: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2488: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2489: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2490:

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

2483: --
2484: -- define cursor and dynamically describe columns of this cursor
2485: --
2486: l_cursor := DBMS_SQL.OPEN_CURSOR;
2487: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2488: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2489: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2490:
2491: --

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

2484: -- define cursor and dynamically describe columns of this cursor
2485: --
2486: l_cursor := DBMS_SQL.OPEN_CURSOR;
2487: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2488: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2489: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2490:
2491: --
2492: -- dynamically define columns of record set

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

2485: --
2486: l_cursor := DBMS_SQL.OPEN_CURSOR;
2487: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
2488: l_exec := DBMS_SQL.EXECUTE(l_cursor);
2489: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
2490:
2491: --
2492: -- dynamically define columns of record set
2493: --

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

2500: l_col_tbl(l_col_name).col_name := l_col_name;
2501: l_col_tbl(l_col_name).col_num := l_col_num;
2502:
2503: IF l_col_name IN('ATTR_GROUP_ID') THEN
2504: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2505: l_attr_group_col_num := l_col_num;
2506: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2507: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2508: l_inv_item_col_num := l_col_num;

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

2503: IF l_col_name IN('ATTR_GROUP_ID') THEN
2504: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2505: l_attr_group_col_num := l_col_num;
2506: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2507: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2508: l_inv_item_col_num := l_col_num;
2509: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2510: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2511: l_org_id_col_num := l_col_num;

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

2506: ELSIF l_col_name IN('INVENTORY_ITEM_ID') THEN
2507: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2508: l_inv_item_col_num := l_col_num;
2509: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2510: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2511: l_org_id_col_num := l_col_num;
2512: ELSIF l_col_name IN('LANGUAGE') THEN
2513: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2514: l_lang_col_num := l_col_num;

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

2509: ELSIF l_col_name IN('ORGANIZATION_ID') THEN
2510: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_num_value);
2511: l_org_id_col_num := l_col_num;
2512: ELSIF l_col_name IN('LANGUAGE') THEN
2513: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2514: l_lang_col_num := l_col_num;
2515: ELSIF l_col_name IN('SOURCE_LANG') THEN
2516: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2517: l_source_lang_col_num := l_col_num;

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

2512: ELSIF l_col_name IN('LANGUAGE') THEN
2513: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2514: l_lang_col_num := l_col_num;
2515: ELSIF l_col_name IN('SOURCE_LANG') THEN
2516: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2517: l_source_lang_col_num := l_col_num;
2518: END IF;
2519:
2520: IF l_used_db_columns_tbl.EXISTS(l_col_name) THEN

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

2517: l_source_lang_col_num := l_col_num;
2518: END IF;
2519:
2520: IF l_used_db_columns_tbl.EXISTS(l_col_name) THEN
2521: DBMS_SQL.DEFINE_COLUMN(l_cursor,l_col_num,l_str_value,l_col_length);
2522: END IF;
2523:
2524: l_col_num := l_rec_tab.NEXT(l_col_num);
2525: EXIT WHEN (l_col_num IS NULL);

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

2535: -- fetch records from dynamic cursor with sql = l_sql
2536: --
2537: LOOP
2538:
2539: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2540: EXIT;
2541: ELSE
2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);

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

2538:
2539: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2540: EXIT;
2541: ELSE
2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2544: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2545: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2546: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);

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

2539: IF DBMS_SQL.FETCH_ROWS(l_cursor)=0 THEN
2540: EXIT;
2541: ELSE
2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2544: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2545: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2546: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2547:

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

2540: EXIT;
2541: ELSE
2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2544: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2545: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2546: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2547:
2548: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);

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

2541: ELSE
2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2544: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2545: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2546: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2547:
2548: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);
2549: l_db_columns_tbl := l_group_database_columns_tbl(l_attr_group_id);

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

2542: DBMS_SQL.COLUMN_VALUE(l_cursor,l_attr_group_col_num,l_attr_group_id);
2543: DBMS_SQL.COLUMN_VALUE(l_cursor,l_inv_item_col_num,l_inventory_item_id);
2544: DBMS_SQL.COLUMN_VALUE(l_cursor,l_org_id_col_num,l_org_id);
2545: DBMS_SQL.COLUMN_VALUE(l_cursor,l_lang_col_num,l_language);
2546: DBMS_SQL.COLUMN_VALUE(l_cursor,l_source_lang_col_num,l_source_lang);
2547:
2548: l_att_names_tbl := l_group_attr_names_tbl(l_attr_group_id);
2549: l_db_columns_tbl := l_group_database_columns_tbl(l_attr_group_id);
2550: l_db_column_types_tbl := l_group_db_column_types_tbl(l_attr_group_id);

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

2559:
2560: --
2561: -- find value of property which is stored in column l_db_columns_tbl(n)
2562: --
2563: DBMS_SQL.COLUMN_VALUE(l_cursor,l_column_num,l_column_value);
2564:
2565: IF l_column_value IS NOT NULL THEN
2566:
2567: l_rec_counter := l_rec_counter + 1;

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

2595: END IF;
2596:
2597: END LOOP; -- end of FOR n IN ...
2598:
2599: END IF; -- end of IF DBMS_SQL.FETCH_ROWS(l_cursor)=0
2600:
2601: IF l_prop_values_tbl.COUNT > 0 AND (l_rec_counter=l_Batch_Size OR FLOOR(l_rec_counter/l_Batch_Size)=0) THEN
2602:
2603: --

Line 2649: DBMS_SQL.CLOSE_CURSOR(l_cursor);

2645:
2646: END LOOP; -- end of looping through l_cursor
2647:
2648: -- close cursor
2649: DBMS_SQL.CLOSE_CURSOR(l_cursor);
2650:
2651: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2652: COMMIT;
2653: