APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on PO_INTERFACE_ERRORS

Line 165: FROM po_interface_errors poie

161: po_attr_values_tlp_interface poai
162: WHERE pohi.batch_id = p_batch_id
163: AND poai.interface_header_id = pohi.interface_header_id
164: AND EXISTS (SELECT 1
165: FROM po_interface_errors poie
166: WHERE poie.interface_header_id = pohi.interface_header_id
167: -- to retireve only those languages for which
168: -- corresponding lines has errors
169: AND (poie.interface_line_id IS NULL OR

Line 362: FROM po_interface_errors poie

358: SELECT distinct poli.ip_category_id
359: FROM po_lines_interface poli
360: WHERE poli.interface_header_id = p_interface_header_id
361: AND EXISTS (SELECT 1
362: FROM po_interface_errors poie
363: WHERE poie.interface_header_id = poli.interface_header_id
364: AND (poie.interface_line_id IS NULL OR
365: poie.interface_line_id = poli.interface_line_id))
366: AND EXISTS (SELECT 1

Line 523: CURSOR interface_errors_cursor(p_interface_header_id po_interface_errors.INTERFACE_HEADER_ID%TYPE)

519: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE)
520: IS
521: --cursor for fetching column value to be populated
522: -- as token value in the error messages table
523: CURSOR interface_errors_cursor(p_interface_header_id po_interface_errors.INTERFACE_HEADER_ID%TYPE)
524: IS
525: SELECT error_message_name,
526: LTRIM(replace(MAX(SYS_CONNECT_BY_PATH(column_value, '**R12MDIGREPL**'))
527: KEEP (DENSE_RANK LAST ORDER BY curr),'**R12MDIGREPL**', ','),',') AS token_value

Line 532: FROM po_interface_errors

528: FROM (SELECT error_message_name,
529: column_value,
530: ROW_NUMBER() OVER (PARTITION BY error_message_name ORDER BY column_value) AS curr,
531: ROW_NUMBER() OVER (PARTITION BY error_message_name ORDER BY column_value) -1 AS prev
532: FROM po_interface_errors
533: WHERE interface_header_id = p_interface_header_id
534: AND error_message_name <> 'ICX_CAT_UPG_ALL_LINES_FAILED'
535: GROUP BY error_message_name, column_value)
536: GROUP BY error_message_name

Line 832: AND EXISTS (SELECT 1 FROM po_interface_errors poie

828: AND poavi.interface_line_id = poli.interface_line_id
829: AND poavti.interface_header_id = poli.interface_header_id
830: AND poavti.interface_line_id = poli.interface_line_id
831: AND poavti.language = :LANGUAGE
832: AND EXISTS (SELECT 1 FROM po_interface_errors poie
833: WHERE poie.interface_header_id = poli.interface_header_id
834: AND (poie.interface_line_id IS NULL OR
835: poie.interface_line_id = poli.interface_line_id))';
836: