APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_ATTRIBUTES_INTERFACE

Line 2819: DELETE FROM pon_attributes_interface

2815:
2816: -- Deletes records from attributes table
2817: v_debug_status := 'DELETE_ATTRIBUTES';
2818:
2819: DELETE FROM pon_attributes_interface
2820: WHERE interface_auction_header_id = p_interface_id;
2821:
2822: -- Delete records from shipments table
2823: v_debug_status := 'DELETE_SHIPMENTS';

Line 3170: FROM pon_attributes_interface

3166: IP_CATEGORY_ID, -- IP_CATEGORY_ID
3167: IP_DESCRIPTOR_ID -- IP_DESCRIPTOR_ID
3168: FROM
3169: (SELECT attribute_name, datatype, value, ip_category_id, ip_descriptor_id
3170: FROM pon_attributes_interface
3171: WHERE interface_auction_header_id = p_interface_id AND
3172: interface_line_number = line.interface_line_number AND
3173: ((ip_category_id = 0 and v_ip_attr_default_option in ('ALL', 'BASE')) or
3174: (ip_category_id <> 0 and v_ip_attr_default_option in ('ALL', 'CATEGORY')))