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.ICX_ITEM_DIAG_GRP dependencies on PO_SESSION_GT

Line 191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';

187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';

Line 197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');

193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:
200: return 'Y';
201: exception when others then

Line 198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;

194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:
200: return 'Y';
201: exception when others then
202: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'init EXCEPTION::'||sqlerrm||' code='||sqlcode);

Line 326: FROM po_session_gt

322: l_api_name CONSTANT VARCHAR2(30) := 'print_file_versions';
323: CURSOR c
324: IS
325: SELECT char1, char2 , char3, char4
326: FROM po_session_gt
327: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key;
328:
329: l_col_val DBMS_SQL.VARCHAR2_TABLE;
330: l_row_val VARCHAR_TABLE;

Line 338: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'Files from po session gt ');

334:
335: ICX_ITEM_DIAG_PVT.file_versions('Y');
336:
337: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'completed ICX_ITEM_DIAG_PVT.file_versions');
338: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'Files from po session gt ');
339: --ol(l_hrd0);
340: OPEN c;
341: FOR i IN 1 .. ICX_ITEM_DIAG_PVT.g_file_count
342: LOOP

Line 343: /* ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'Files from po session gt i='|| i);

339: --ol(l_hrd0);
340: OPEN c;
341: FOR i IN 1 .. ICX_ITEM_DIAG_PVT.g_file_count
342: LOOP
343: /* ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'Files from po session gt i='|| i);
344: FETCH c INTO l_hrd3;
345:
346: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_hrd3);
347: l_hrd3 := l_hrd1 || l_hrd3 || l_hrd2;

Line 381: FROM po_session_gt

377: l_c_row varchar2(10);
378: l_ret boolean := false;
379: cursor c is
380: SELECT 'TRUE' from dual where exists (select 'Y'
381: FROM po_session_gt
382: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
383: and char4 = 'TRUE' );
384: begin
385: