APPS.ICX_ITEM_DIAG_PVT dependencies on PO_SESSION_GT

Line 35: INSERT INTO po_session_gt

31: char4 IN VARCHAR2 default null,
32: char5 IN VARCHAR2 default null)
33: is
34: begin
35: INSERT INTO po_session_gt
36: (index_char1
37: ,num1
38: ,num2
39: ,num3

Line 128: UPDATE po_session_gt

124: l_api_name varchar2(30):= 'check_file';
125: BEGIN
126: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start check_file');
127: forall i IN 1 .. g_file_count
128: UPDATE po_session_gt
129: SET num3 = update_num( g_instance_versions_tbl(i) ) ,
130: num2 = update_num( g_file_versions_tbl(i) )
131: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
132: AND char1 = g_file_tbl(i);

Line 137: FROM po_session_gt

133:
134: for i IN 1 .. g_file_count loop
135: -- check if instance file is less than should have version then update apply patch as Y
136: select char2, char3, num2, num3 into l_shld_ver, l_inst_ver , l_num2,l_num3
137: FROM po_session_gt
138: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
139: AND char1 = g_file_tbl(i);
140:
141: if ( l_num2 <> l_num3) then

Line 171: UPDATE po_session_gt set char4 = l_apply_patch

167: l_apply_patch:= 'FALSE';
168: end if;
169: end if;
170: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 check_file' ||g_file_tbl(i) || l_apply_patch);
171: UPDATE po_session_gt set char4 = l_apply_patch
172: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
173: AND char1 = g_file_tbl(i);
174:
175: end loop;

Line 269: INTO po_session_gt

265: FOR i IN 1 .. g_file_count
266: LOOP
267: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start of insert '|| i || ' file :' || g_file_tbl(i)||g_file_versions_tbl(i)|| g_instance_versions_tbl(i));
268: INSERT
269: INTO po_session_gt
270: (
271: index_char1 --'ITEM_DIAG_FILE_VERSIONS'
272: ,
273: char1 -- pls file name

Line 331: FROM po_session_gt

327: char3,
328: num1,
329: num2,
330: num3
331: FROM po_session_gt
332: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_file_key;
333:
334: l_limit NUMBER:=100;
335: BEGIN

Line 538: from po_session_gt

534: and org_id = g_org_id;
535:
536: cursor po_gt is
537: select index_char1,num1,num2,num3,num4,char1,char2,char3,char4
538: from po_session_gt
539: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_error_key ;
540:
541: l_api_name VARCHAR2 (20):='get_IDs_values';
542:

Line 1042: elsif p_table_name = 'PO_SESSION_GT' then

1038: p_col_num :=10;
1039: p_row_num:=p_row_num-1;
1040: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1041:
1042: elsif p_table_name = 'PO_SESSION_GT' then
1043: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'13');
1044: p_col_val(1):='INDEX_CHAR1';
1045: p_col_val(2):='NUM1';
1046: p_col_val(3):='NUM2';

Line 1313: select distinct to_number(CHAR4) from po_session_gt

1309: l_option_value varchar2(10);
1310: l_api_name VARCHAR2 (20):='create_missing_data';
1311:
1312: cursor create_ip_cat is
1313: select distinct to_number(CHAR4) from po_session_gt
1314: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1315: and CHAR1='IP_CATEGORY_MISSING';
1316:
1317: cursor create_mappings is

Line 1318: select distinct to_number(CHAR4) from po_session_gt

1314: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1315: and CHAR1='IP_CATEGORY_MISSING';
1316:
1317: cursor create_mappings is
1318: select distinct to_number(CHAR4) from po_session_gt
1319: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1320: and CHAR1=g_error_code(3)
1321: AND CHAR4 NOT IN (select distinct CHAR4 from po_session_gt
1322: where INDEX_CHAR1='ITEM_DIAG_ERRORS'

Line 1321: AND CHAR4 NOT IN (select distinct CHAR4 from po_session_gt

1317: cursor create_mappings is
1318: select distinct to_number(CHAR4) from po_session_gt
1319: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1320: and CHAR1=g_error_code(3)
1321: AND CHAR4 NOT IN (select distinct CHAR4 from po_session_gt
1322: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1323: and CHAR1='IP_CATEGORY_MISSING') ;
1324:
1325: cursor create_ctx_hdrs is

Line 1326: select distinct num1, num2 from po_session_gt

1322: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1323: and CHAR1='IP_CATEGORY_MISSING') ;
1324:
1325: cursor create_ctx_hdrs is
1326: select distinct num1, num2 from po_session_gt
1327: where INDEX_CHAR1='ITEM_DIAG_ERRORS'
1328: and CHAR1='ICX_CTX_HDRS_MISSING';
1329:
1330: l_inv_item_id number;