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 334: pon_auction_attributes auction_attributes

330: update pon_auc_attributes_interface interface_attribute
331: set display_target_flag =
332: (select display_target_flag
333: from
334: pon_auction_attributes auction_attributes
335: where
336: auction_attributes.auction_header_id = interface_attribute.auction_header_id
337: and auction_attributes.line_number = interface_attribute.auction_line_number
338: and auction_attributes.attribute_name = interface_attribute.attribute_name

Line 346: pon_auction_attributes auction_attributes

342: and exists
343: (select 'x'
344: from
345: pon_item_prices_interface item_interface,
346: pon_auction_attributes auction_attributes
347: where
348: item_interface.batch_id = p_batch_id
349: and item_interface.action = g_update_action
350: and item_interface.auction_line_number = interface_attribute.auction_line_number

Line 687: PON_AUCTION_ATTRIBUTES

683: that were marked as deleted in the spreadsheet. The records will
684: be deleted from the tables in the following order. For LOTS and
685: GROUP marked as deleted the corresponding children are also deleted.
686: PON_ATTRIBUTE_SCORES
687: PON_AUCTION_ATTRIBUTES
688: PON_PF_SUPPLIER_VALUES
689: PON_PRICE_ELEMENTS
690: PON_PRICE_DIFFERENTIALS
691: PON_AUCTION_SHIPMENTS_ALL

Line 751: --delete from PON_AUCTION_ATTRIBUTES

747: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
748: print_debug_log(l_module,'DELETE_LINES_WITH_CHILDREN START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
749: END IF;
750:
751: --delete from PON_AUCTION_ATTRIBUTES
752: if(g_line_attribute_enabled = 'Y') then
753:
754: --delete from PON_ATTRIBUTE_SCORES
755: if(g_attribute_score_enabled_flag = 'Y') then

Line 776: --delete from PON_AUCTION_ATTRIBUTES

772: and auction_scores.line_number = p1.auction_line_number);
773: END IF;
774:
775:
776: --delete from PON_AUCTION_ATTRIBUTES
777: delete from pon_auction_attributes auction_attributes
778: where
779: auction_header_id = g_auction_header_id
780: and exists

Line 777: delete from pon_auction_attributes auction_attributes

773: END IF;
774:
775:
776: --delete from PON_AUCTION_ATTRIBUTES
777: delete from pon_auction_attributes auction_attributes
778: where
779: auction_header_id = g_auction_header_id
780: and exists
781: (select

Line 1315: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will

1311: PARAMETERS: NONE
1312:
1313: COMMENT : This procedure will add the attributes corresponding to the new
1314: lines from the PON_AUC_ATTRIBUTES_INTERFACE interface table to the
1315: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will
1316: be used for the same. The logic for this is present in copyAttributes
1317: method in NegItemSpreadsheetAMImpl.
1318: ======================================================================*/
1319: PROCEDURE ADD_ATTRIBUTES is

Line 1329: insert into pon_auction_attributes

1325: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1326: print_debug_log(l_module,'ADD_ATTRIBUTES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1327: END IF;
1328:
1329: insert into pon_auction_attributes
1330: fields
1331: (AUCTION_HEADER_ID,
1332: LINE_NUMBER,
1333: SEQUENCE_NUMBER,

Line 1469: pon_auction_attributes template_attribute,

1465: FROM
1466: pon_auction_headers_all pah1,
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,
1471: pon_auc_attributes_interface interface_attributes
1472: WHERE
1473: pah1.auction_header_id = g_auction_header_id

Line 1470: pon_auction_attributes auction_attributes,

1466: pon_auction_headers_all pah1,
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,
1471: pon_auc_attributes_interface interface_attributes
1472: WHERE
1473: pah1.auction_header_id = g_auction_header_id
1474: and template.auction_header_id = pah1.template_id

Line 1662: from pon_auction_attributes paa

1658: paip.ip_category_id is not null and
1659: nvl(p1.ip_category_id, -1) <> nvl(paip.ip_category_id, -1))) pas
1660: where auction_header_id = g_auction_header_id and
1661: exists (select null
1662: from pon_auction_attributes paa
1663: where paa.auction_header_id = pas.auction_header_id and
1664: paa.line_number = pas.line_number and
1665: paa.sequence_number = pas.attribute_sequence_number and
1666: paa.ip_category_id is not null and

Line 1670: delete from pon_auction_attributes paa

1666: paa.ip_category_id is not null and
1667: paa.ip_category_id <> 0);
1668:
1669: -- 2) then delete attributes
1670: delete from pon_auction_attributes paa
1671: where paa.auction_header_id = g_auction_header_id and
1672: paa.ip_category_id is not null and
1673: paa.ip_category_id <> 0 and
1674: paa.line_number in (select paip.line_number

Line 2203: pon_auction_attributes auction_attributes,

2199: bulk collect into
2200: l_attribute_seq_number,
2201: l_line_number
2202: from
2203: pon_auction_attributes auction_attributes,
2204: pon_item_prices_interface line_interface
2205: where
2206: line_interface.action = g_update_action
2207: and line_interface.batch_id = g_batch_id

Line 2242: pon_auction_attributes auction_attributes,

2238: bulk collect into
2239: l_attribute_name,
2240: l_line_number
2241: from
2242: pon_auction_attributes auction_attributes,
2243: pon_item_prices_interface line_interface
2244: where
2245: line_interface.action = g_update_action
2246: and line_interface.batch_id = g_batch_id

Line 2262: delete from pon_auction_attributes auction_attributes

2258: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2259: and interface_attributes.attribute_name = auction_attributes.attribute_name);
2260:
2261: FORALL x in 1..l_line_number.COUNT
2262: delete from pon_auction_attributes auction_attributes
2263: where
2264: auction_attributes.auction_header_id = g_auction_header_id
2265: and auction_attributes.line_number = l_line_number(x)
2266: and auction_attributes.attribute_name = l_attribute_name(x);

Line 2302: pon_auction_attributes auction_attributes

2298: l_attr_disp_seq_number
2299: from
2300: pon_item_prices_interface line_interface,
2301: pon_auc_attributes_interface interface_attributes,
2302: pon_auction_attributes auction_attributes
2303: where
2304: interface_attributes.batch_id = g_batch_id
2305: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2306: and interface_attributes.auction_line_number = auction_attributes.line_number

Line 2313: update pon_auction_attributes auction_attributes

2309: and line_interface.batch_id = interface_attributes.batch_id
2310: and line_interface.action = g_update_action;
2311:
2312: FORALL x in 1..l_line_number.COUNT
2313: update pon_auction_attributes auction_attributes
2314: set
2315: attr_group = l_attr_group(x),
2316: mandatory_flag = l_mandatory_flag(x),
2317: display_only_flag = l_display_only_flag(x),

Line 2339: pon_auction_attributes

2335: SELECT nvl(max(SEQUENCE_NUMBER),10)
2336: into
2337: l_max_neg_line_attr_seq_num
2338: FROM
2339: pon_auction_attributes
2340: WHERE
2341: AUCTION_HEADER_ID = g_auction_header_id;
2342:
2343: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2349: insert into pon_auction_attributes

2345: ' g_auction_header_id '||g_auction_header_id ||
2346: ' l_max_neg_line_attr_seq_num = '||l_max_neg_line_attr_seq_num);
2347: END IF;
2348:
2349: insert into pon_auction_attributes
2350: fields
2351: (AUCTION_HEADER_ID,
2352: LINE_NUMBER,
2353: SEQUENCE_NUMBER,

Line 2410: pon_auction_attributes auction_attributes

2406: and p1.action = g_update_action
2407: and paa_int.auction_line_number = p1.auction_line_number
2408: and not exists (select 'x'
2409: from
2410: pon_auction_attributes auction_attributes
2411: where
2412: paa_int.auction_header_id = auction_attributes.auction_header_id
2413: and paa_int.auction_line_number = auction_attributes.line_number
2414: and paa_int.attribute_name = auction_attributes.attribute_name)