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_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUCTION_ATTRIBUTES

Line 339: pon_auction_attributes auction_attributes

335: update pon_auc_attributes_interface interface_attribute
336: set display_target_flag =
337: (select display_target_flag
338: from
339: pon_auction_attributes auction_attributes
340: where
341: auction_attributes.auction_header_id = interface_attribute.auction_header_id
342: and auction_attributes.line_number = interface_attribute.auction_line_number
343: and auction_attributes.attribute_name = interface_attribute.attribute_name

Line 351: pon_auction_attributes auction_attributes

347: and exists
348: (select 'x'
349: from
350: pon_item_prices_interface item_interface,
351: pon_auction_attributes auction_attributes
352: where
353: item_interface.batch_id = p_batch_id
354: and item_interface.action = g_update_action
355: and item_interface.auction_line_number = interface_attribute.auction_line_number

Line 692: PON_AUCTION_ATTRIBUTES

688: that were marked as deleted in the spreadsheet. The records will
689: be deleted from the tables in the following order. For LOTS and
690: GROUP marked as deleted the corresponding children are also deleted.
691: PON_ATTRIBUTE_SCORES
692: PON_AUCTION_ATTRIBUTES
693: PON_PF_SUPPLIER_VALUES
694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS
696: PON_AUCTION_SHIPMENTS_ALL

Line 763: --delete from PON_AUCTION_ATTRIBUTES

759: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
760: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
761: END IF;
762:
763: --delete from PON_AUCTION_ATTRIBUTES
764: if(g_line_attribute_enabled = 'Y') then
765:
766: --delete from PON_ATTRIBUTE_SCORES
767: if(g_attribute_score_enabled_flag = 'Y') then

Line 790: --delete from PON_AUCTION_ATTRIBUTES

786: and auction_scores.line_number = p1.auction_line_number);
787: END IF;
788:
789:
790: --delete from PON_AUCTION_ATTRIBUTES
791: delete from pon_auction_attributes auction_attributes
792: where
793: auction_header_id = g_auction_header_id
794: and exists

Line 791: delete from pon_auction_attributes auction_attributes

787: END IF;
788:
789:
790: --delete from PON_AUCTION_ATTRIBUTES
791: delete from pon_auction_attributes auction_attributes
792: where
793: auction_header_id = g_auction_header_id
794: and exists
795: (select

Line 1537: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will

1533: PARAMETERS: NONE
1534:
1535: COMMENT : This procedure will add the attributes corresponding to the new
1536: lines from the PON_AUC_ATTRIBUTES_INTERFACE interface table to the
1537: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will
1538: be used for the same. The logic for this is present in copyAttributes
1539: method in NegItemSpreadsheetAMImpl.
1540: ======================================================================*/
1541: PROCEDURE ADD_ATTRIBUTES is

Line 1551: insert into pon_auction_attributes

1547: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1548: print_debug_log(l_module,'ADD_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1549: END IF;
1550:
1551: insert into pon_auction_attributes
1552: fields
1553: (AUCTION_HEADER_ID,
1554: LINE_NUMBER,
1555: SEQUENCE_NUMBER,

Line 1691: pon_auction_attributes template_attribute,

1687: FROM
1688: pon_auction_headers_all pah1,
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,
1693: pon_auc_attributes_interface interface_attributes
1694: WHERE
1695: pah1.auction_header_id = g_auction_header_id

Line 1692: pon_auction_attributes auction_attributes,

1688: pon_auction_headers_all pah1,
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,
1693: pon_auc_attributes_interface interface_attributes
1694: WHERE
1695: pah1.auction_header_id = g_auction_header_id
1696: and template.auction_header_id = pah1.template_id

Line 1895: from pon_auction_attributes paa

1891: paip.ip_category_id is not null and
1892: nvl(p1.ip_category_id, -1) <> nvl(paip.ip_category_id, -1))) pas
1893: where auction_header_id = g_auction_header_id and
1894: exists (select null
1895: from pon_auction_attributes paa
1896: where paa.auction_header_id = pas.auction_header_id and
1897: paa.line_number = pas.line_number and
1898: paa.sequence_number = pas.attribute_sequence_number and
1899: paa.ip_category_id is not null and

Line 1903: delete from pon_auction_attributes paa

1899: paa.ip_category_id is not null and
1900: paa.ip_category_id <> 0);
1901:
1902: -- 2) then delete attributes
1903: delete from pon_auction_attributes paa
1904: where paa.auction_header_id = g_auction_header_id and
1905: paa.ip_category_id is not null and
1906: paa.ip_category_id <> 0 and
1907: paa.line_number in (select paip.line_number

Line 2464: pon_auction_attributes auction_attributes,

2460: bulk collect into
2461: l_attribute_seq_number,
2462: l_line_number
2463: from
2464: pon_auction_attributes auction_attributes,
2465: pon_item_prices_interface line_interface
2466: where
2467: line_interface.action = g_update_action
2468: and line_interface.batch_id = g_batch_id

Line 2503: pon_auction_attributes auction_attributes,

2499: bulk collect into
2500: l_attribute_name,
2501: l_line_number
2502: from
2503: pon_auction_attributes auction_attributes,
2504: pon_item_prices_interface line_interface
2505: where
2506: line_interface.action = g_update_action
2507: and line_interface.batch_id = g_batch_id

Line 2523: delete from pon_auction_attributes auction_attributes

2519: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2520: and interface_attributes.attribute_name = auction_attributes.attribute_name);
2521:
2522: FORALL x in 1..l_line_number.COUNT
2523: delete from pon_auction_attributes auction_attributes
2524: where
2525: auction_attributes.auction_header_id = g_auction_header_id
2526: and auction_attributes.line_number = l_line_number(x)
2527: and auction_attributes.attribute_name = l_attribute_name(x);

Line 2563: pon_auction_attributes auction_attributes

2559: l_attr_disp_seq_number
2560: from
2561: pon_item_prices_interface line_interface,
2562: pon_auc_attributes_interface interface_attributes,
2563: pon_auction_attributes auction_attributes
2564: where
2565: interface_attributes.batch_id = g_batch_id
2566: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2567: and interface_attributes.auction_line_number = auction_attributes.line_number

Line 2574: update pon_auction_attributes auction_attributes

2570: and line_interface.batch_id = interface_attributes.batch_id
2571: and line_interface.action = g_update_action;
2572:
2573: FORALL x in 1..l_line_number.COUNT
2574: update pon_auction_attributes auction_attributes
2575: set
2576: attr_group = l_attr_group(x),
2577: mandatory_flag = l_mandatory_flag(x),
2578: display_only_flag = l_display_only_flag(x),

Line 2600: pon_auction_attributes

2596: SELECT nvl(max(SEQUENCE_NUMBER),10)
2597: into
2598: l_max_neg_line_attr_seq_num
2599: FROM
2600: pon_auction_attributes
2601: WHERE
2602: AUCTION_HEADER_ID = g_auction_header_id;
2603:
2604: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2610: insert into pon_auction_attributes

2606: ' g_auction_header_id '||g_auction_header_id ||
2607: ' l_max_neg_line_attr_seq_num = '||l_max_neg_line_attr_seq_num);
2608: END IF;
2609:
2610: insert into pon_auction_attributes
2611: fields
2612: (AUCTION_HEADER_ID,
2613: LINE_NUMBER,
2614: SEQUENCE_NUMBER,

Line 2671: pon_auction_attributes auction_attributes

2667: and p1.action = g_update_action
2668: and paa_int.auction_line_number = p1.auction_line_number
2669: and not exists (select 'x'
2670: from
2671: pon_auction_attributes auction_attributes
2672: where
2673: paa_int.auction_header_id = auction_attributes.auction_header_id
2674: and paa_int.auction_line_number = auction_attributes.line_number
2675: and paa_int.attribute_name = auction_attributes.attribute_name)