DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_LOOKUP_VALUES

Line 1138: v_attr_group_name fnd_lookup_values.meaning%TYPE;

1134: v_contract_type pon_auction_headers_all.contract_type%TYPE;
1135: v_buyer_id NUMBER;
1136: v_ip_attr_default_option VARCHAR2(10);
1137: v_default_attr_group pon_auction_attributes.attr_group%TYPE;
1138: v_attr_group_name fnd_lookup_values.meaning%TYPE;
1139: v_max_seq_number NUMBER;
1140: v_line_number NUMBER;
1141: v_ip_category_id NUMBER;
1142: v_debug_status VARCHAR2(100);

Line 1185: fnd_lookup_values flv

1181: flv.meaning
1182: into v_default_attr_group,
1183: v_attr_group_name
1184: from pon_party_preferences ppp,
1185: fnd_lookup_values flv
1186: where ppp.app_short_name = 'PON' and
1187: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
1188: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and
1189: flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS' and