APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_ATTRIBUTES_INTERFACE

Line 2334: DELETE FROM pon_attributes_interface

2330:
2331: -- Deletes records from attributes table
2332: v_debug_status := 'DELETE_ATTRIBUTES';
2333:
2334: DELETE FROM pon_attributes_interface
2335: WHERE interface_auction_header_id = p_interface_id;
2336:
2337: -- Delete records from shipments table
2338: v_debug_status := 'DELETE_SHIPMENTS';

Line 2671: FROM pon_attributes_interface

2667: IP_CATEGORY_ID, -- IP_CATEGORY_ID
2668: IP_DESCRIPTOR_ID -- IP_DESCRIPTOR_ID
2669: FROM
2670: (SELECT attribute_name, datatype, value, ip_category_id, ip_descriptor_id
2671: FROM pon_attributes_interface
2672: WHERE interface_auction_header_id = p_interface_id AND
2673: interface_line_number = line.interface_line_number AND
2674: ((ip_category_id = 0 and v_ip_attr_default_option in ('ALL', 'BASE')) or
2675: (ip_category_id <> 0 and v_ip_attr_default_option in ('ALL', 'CATEGORY')))