APPS.PON_DATATEMPLATE_PKG dependencies on PON_AUCTION_ITEM_PRICES_EXT_B

Line 166: and potu.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_ITEM_PRICES_EXT_B

162: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
163: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
164: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
165: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
166: and potu.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_ITEM_PRICES_EXT_B
167: where AUCTION_HEADER_ID = L.auction_header_id and LINE_NUMBER=L.LINE_NUMBER and attr_group_id = potu.attribute_group_id)
168: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;
169:
170: CURSOR C_ATTR_MD(P_ATTR_GROUP VARCHAR2, P_DESC_FLEXFLD_NAME VARCHAR2) IS

Line 203: p_object_name varchar2(200) := 'PON_AUCTION_ITEM_PRICES_EXT_B';

199: p_attr_internal_name varchar2(100);
200: p_attr_group_type varchar2(200) := 'PON_AUC_PRICES_EXT_ATTRS';
201: p_attr_group_int_name varchar2(200);
202:
203: p_object_name varchar2(200) := 'PON_AUCTION_ITEM_PRICES_EXT_B';
204:
205: p_pk1_column_name varchar2(200) := 'AUCTION_HEADER_ID';
206: p_pk1_value number := p_auction_header_id;
207: p_pk2_column_name varchar2(200) := 'LINE_NUMBER';

Line 507: l_fobsql := 'select count(extension_id) from pon_auction_item_prices_ext_b where auction_header_id =:1 and attr_group_id = :2 and nvl(' || fob_db_col || ', ''N'') <> ''DEST''';

503: and a.attr_name like 'FOB'
504: and av.attr_group_type = a.attr_group_type
505: and av.attr_group_name = a.attr_group_name;
506:
507: l_fobsql := 'select count(extension_id) from pon_auction_item_prices_ext_b where auction_header_id =:1 and attr_group_id = :2 and nvl(' || fob_db_col || ', ''N'') <> ''DEST''';
508:
509: execute immediate l_fobsql into l_countdest using p_auction_header_id,l_attr_group_id;
510:
511: if (l_countdest = 0) then