DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_ATTRIBUTES_INTERFACE

Line 1967: FROM pon_attributes_interface

1963: v_msg_data VARCHAR2(400);
1964: CURSOR catalogLines
1965: IS
1966: SELECT DISTINCT interface_line_number
1967: FROM pon_attributes_interface
1968: WHERE interface_auction_header_id = p_document_number;
1969: CURSOR nonCatalogLines
1970: IS
1971: SELECT DISTINCT paip.line_number,

Line 2102: FROM pon_attributes_interface

2098: datatype,
2099: value,
2100: ip_category_id,
2101: ip_descriptor_id
2102: FROM pon_attributes_interface
2103: WHERE interface_auction_header_id = P_DOCUMENT_NUMBER
2104: AND interface_line_number = v_line_number
2105: AND ((ip_category_id = 0
2106: AND v_ip_attr_default_option IN ('ALL', 'BASE'))

Line 2113: FROM PON_ATTRIBUTES_INTERFACE

2109: ORDER BY NVL(interface_sequence_number, v_max_seq_number) ASC
2110: );
2111: END LOOP;
2112: DELETE
2113: FROM PON_ATTRIBUTES_INTERFACE
2114: WHERE interface_auction_header_id = P_DOCUMENT_NUMBER;
2115:
2116: FOR nonCatalogLine IN nonCatalogLines
2117: LOOP