APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_ATTRIBUTES_INTERFACE

Line 1150: FROM pon_attributes_interface

1146: v_msg_data VARCHAR2(400);
1147:
1148: CURSOR catalogLines IS
1149: SELECT distinct interface_line_number
1150: FROM pon_attributes_interface
1151: WHERE interface_auction_header_id = p_document_number;
1152:
1153:
1154: CURSOR nonCatalogLines IS

Line 1283: FROM pon_attributes_interface

1279: IP_DESCRIPTOR_ID -- IP_DESCRIPTOR_ID
1280: FROM
1281: (SELECT interface_line_number, attribute_name, datatype,
1282: value, ip_category_id, ip_descriptor_id
1283: FROM pon_attributes_interface
1284: WHERE interface_auction_header_id = P_DOCUMENT_NUMBER AND
1285: interface_line_number = v_line_number AND
1286: ((ip_category_id = 0 and v_ip_attr_default_option in ('ALL', 'BASE')) or
1287: (ip_category_id <> 0 and v_ip_attr_default_option in ('ALL', 'CATEGORY')))

Line 1292: DELETE FROM PON_ATTRIBUTES_INTERFACE

1288: ORDER BY nvl(interface_sequence_number, v_max_seq_number) asc);
1289:
1290: END LOOP;
1291:
1292: DELETE FROM PON_ATTRIBUTES_INTERFACE
1293: WHERE interface_auction_header_id = P_DOCUMENT_NUMBER;
1294:
1295:
1296: FOR nonCatalogLine in nonCatalogLines