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.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTR_VALUES_INTERFACE

Line 221: FROM pon_bid_attr_values_interface bai

217: -- No attributes
218: AND (al.has_attributes_flag = 'N'
219: OR NOT EXISTS -- no attributes
220: (SELECT bai.attribute_name
221: FROM pon_bid_attr_values_interface bai
222: WHERE bai.batch_id = bli.batch_id
223: AND bai.interface_line_id = bli.interface_line_id
224: AND bai.value IS NOT null))));
225:

Line 314: DELETE FROM pon_bid_attr_values_interface bai

310: -- from the interface tables, along with their children
311: -- flag 'N' indicates that only erroneous records are to be purged
312:
313: -- Delete from attributes interface table
314: DELETE FROM pon_bid_attr_values_interface bai
315: WHERE bai.batch_id = p_batch_id
316: AND bai.interface_line_id in (
317: select bli.interface_line_id
318: from pon_bid_item_prices_interface bli

Line 355: UPDATE pon_bid_attr_values_interface bai

351:
352: -- Update attributes' internal line numbers's
353: -- NOTE: we also update line_number for those attributes with
354: -- valid line_numbers
355: UPDATE pon_bid_attr_values_interface bai
356: SET bai.line_number =
357: (SELECT bli.line_number
358: FROM pon_bid_item_prices_interface bli
359: WHERE bli.batch_id = bai.batch_id

Line 400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

396: p_suffix IN VARCHAR2,
397: p_batch_id IN pon_interface_errors.batch_id%TYPE,
398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;

397: p_batch_id IN pon_interface_errors.batch_id%TYPE,
398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

Line 402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;

398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
406:

Line 403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;

399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
406:
407: l_int_lines intLineTab;

Line 404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;

400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
406:
407: l_int_lines intLineTab;
408: l_line_numbers lineNumberTab;

Line 438: FROM pon_bid_attr_values_interface bai,

434: l_attr_names,
435: l_datatypes,
436: l_values,
437: l_disp_line_numbers
438: FROM pon_bid_attr_values_interface bai,
439: pon_auction_item_prices_all al
440: WHERE bai.batch_id = p_batch_id
441: AND al.auction_header_id = bai.auction_header_id
442: AND al.line_number = bai.line_number;

Line 446: UPDATE pon_bid_attr_values_interface bai

442: AND al.line_number = bai.line_number;
443:
444: -- Mark every attribute as invalid
445: -- The following statement will re-validate each attribute
446: UPDATE pon_bid_attr_values_interface bai
447: SET bai.line_number = g_error_int
448: WHERE bai.batch_id = p_batch_id;
449:
450: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');

Line 457: UPDATE pon_bid_attr_values_interface bai

453: l_grouping_separator_character := SUBSTR(l_numeric_characters, 2, 1);
454:
455: -- Attempt the datatype conversions
456: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
457: UPDATE pon_bid_attr_values_interface bai
458: SET bai.value = decode(l_datatypes(i),
459: 'TXT', l_values(i),
460: 'NUM', to_char(to_number(replace(l_values(i), l_grouping_separator_character), 'FM9999999999999999999999999999999999999999999999D9999999999999999', 'NLS_NUMERIC_CHARACTERS=''' || l_numeric_characters || ''''),
461: decode(instr(l_values(i), l_decimal_separator_character),

Line 576: UPDATE pon_bid_attr_values_interface bai

572:
573: -- Determine if there are any invalid attributes.
574: -- line_number is assigned a sentinel indicating an error
575: -- instead of attribute_name since attribute_name is a string.
576: UPDATE pon_bid_attr_values_interface bai
577: SET bai.line_number =
578: nvl((SELECT ba.line_number
579: FROM pon_bid_attribute_values ba
580: WHERE ba.bid_number = bai.bid_number

Line 600: DELETE FROM pon_bid_attr_values_interface bai

596:
597: WHERE bai.batch_id = p_batch_id;
598:
599: --bug 5166407: ignore the display only attributes
600: DELETE FROM pon_bid_attr_values_interface bai
601: WHERE bai.batch_id = p_batch_id
602: AND (bai.bid_number, bai.line_number, bai.sequence_number) in
603: (
604: select bh.bid_number, bh.line_number, aa.sequence_number

Line 651: FROM pon_bid_attr_values_interface bai

647: bai.auction_header_id,
648: bai.bid_number,
649: bai.line_number,
650: g_exp_date
651: FROM pon_bid_attr_values_interface bai
652: WHERE bai.batch_id = p_batch_id
653: AND bai.line_number = g_error_int);
654:
655: -- Remove all invalid attributes before validating datatypes

Line 658: DELETE FROM pon_bid_attr_values_interface bai

654:
655: -- Remove all invalid attributes before validating datatypes
656:
657: -- Delete from attributes interface table
658: DELETE FROM pon_bid_attr_values_interface bai
659: WHERE bai.batch_id = p_batch_id
660: AND bai.line_number = g_error_int;
661:
662: -- Validate attributes' datatypes

Line 672: DELETE FROM pon_bid_attr_values_interface bai

668: p_batch_id,
669: p_request_id);
670:
671: -- Delete from attributes interface table
672: DELETE FROM pon_bid_attr_values_interface bai
673: WHERE bai.batch_id = p_batch_id
674: AND bai.line_number = g_error_int;
675:
676: -- 2. PRICE ELEMENTS/COST FACTORS

Line 1054: FROM pon_bid_attr_values_interface

1050: sequence_number,
1051: value,
1052: worksheet_name,
1053: worksheet_sequence_number
1054: FROM pon_bid_attr_values_interface
1055: WHERE auction_header_id = p_auction_header_id
1056: AND bid_number = p_bid_number
1057: AND batch_id = p_batch_id) bai
1058: ON (ba.auction_header_id = bai.auction_header_id

Line 1303: DELETE FROM pon_bid_attr_values_interface bai

1299: -- Remove all records for the current batch from the interface table
1300: DELETE FROM pon_bid_item_prices_interface bli
1301: WHERE bli.batch_id = p_batch_id;
1302:
1303: DELETE FROM pon_bid_attr_values_interface bai
1304: WHERE bai.batch_id = p_batch_id;
1305:
1306: DELETE FROM pon_bid_price_elements_int bpfi
1307: WHERE bpfi.batch_id = p_batch_id;

Line 2181: FROM pon_bid_attr_values_interface bai

2177: -- No attributes
2178: AND (al.has_attributes_flag = 'N'
2179: OR NOT EXISTS -- no attributes
2180: (SELECT bai.attribute_name
2181: FROM pon_bid_attr_values_interface bai
2182: WHERE bai.batch_id = bli.batch_id
2183: AND bai.line_number = bli.line_number
2184: AND bai.value IS NOT null))
2185: -- No payments

Line 2224: DELETE FROM pon_bid_attr_values_interface bai

2220: -- determine_xml_closed_lines(p_auc_header_id, p_batch_id, p_request_id, p_userid, p_suffix);
2221: -- end if;
2222:
2223: -- delete bid attribute values from interface tables
2224: DELETE FROM pon_bid_attr_values_interface bai
2225: WHERE bai.batch_id = p_batch_id
2226: AND bai.line_number in (
2227: select bli.line_number
2228: from pon_bid_item_prices_interface bli

Line 2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

2286: p_request_id IN pon_interface_errors.request_id%TYPE
2287: ) IS
2288: -- Define table definitions
2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2297:
2298: -- Local table variables

Line 2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2297:
2298: -- Local table variables
2299: l_line_numbers lineNumberTable;

Line 2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2297:
2298: -- Local table variables
2299: l_line_numbers lineNumberTable;
2300: l_int_lines intLineTable;

Line 2362: pon_bid_attr_values_interface pbai,

2358: l_values,
2359: l_worksheet_names,
2360: l_worksheet_seq_numbers
2361: FROM
2362: pon_bid_attr_values_interface pbai,
2363: pon_auction_attributes paa
2364: WHERE
2365: pbai.auction_header_id = p_auction_header_id
2366: AND pbai.bid_number = p_bid_number

Line 2375: UPDATE pon_bid_attr_values_interface pbai

2371: AND pbai.sequence_number = paa.sequence_number;
2372:
2373: -- Attempt the datatype conversions
2374: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
2375: UPDATE pon_bid_attr_values_interface pbai
2376: SET pbai.value = decode(l_datatypes(i),
2377: 'TXT', l_values(i),
2378: 'NUM', to_char(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,'''),
2379: decode(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''') - floor(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''')),

Line 2454: pon_bid_attr_values_interface pbai

2450: l_worksheet_seq_numbers(l_index),
2451: 'PON_AUC_REQUIREMENTS');
2452:
2453: UPDATE
2454: pon_bid_attr_values_interface pbai
2455: SET
2456: pbai.value = null
2457: WHERE
2458: pbai.auction_header_id = p_auction_header_id

Line 2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

2478: ) IS
2479: -- Define table definitions
2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2489:
2490: -- Local table variables

Line 2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2489:
2490: -- Local table variables
2491: l_disp_line_numbers docDispLineNumTable;

Line 2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2489:
2490: -- Local table variables
2491: l_disp_line_numbers docDispLineNumTable;
2492: l_line_numbers lineNumberTable;

Line 2558: pon_bid_attr_values_interface pbai,

2554: l_values,
2555: l_worksheet_names,
2556: l_worksheet_seq_numbers
2557: FROM
2558: pon_bid_attr_values_interface pbai,
2559: pon_auction_attributes paa,
2560: pon_auction_item_prices_all paip
2561: WHERE
2562: pbai.auction_header_id = p_auction_header_id

Line 2574: UPDATE pon_bid_attr_values_interface pbai

2570: AND paa.line_number = paip.line_number;
2571:
2572: -- Attempt the datatype conversions
2573: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
2574: UPDATE pon_bid_attr_values_interface pbai
2575: SET pbai.value = decode(l_datatypes(i),
2576: 'TXT', l_values(i),
2577: 'NUM', to_char(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,'''),
2578: decode(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''') - floor(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''')),

Line 2661: pon_bid_attr_values_interface pbai

2657: l_worksheet_seq_numbers(l_index),
2658: 'PON_AUC_ATTRIBUTES');
2659:
2660: UPDATE
2661: pon_bid_attr_values_interface pbai
2662: SET
2663: pbai.value = null
2664: WHERE
2665: pbai.auction_header_id = p_auction_header_id