PACKAGE: APPS.PON_RESPONSE_IMPORT_PKG

Source

1 PACKAGE PON_RESPONSE_IMPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: PONRIMPS.pls 120.9.12020000.2 2013/04/18 05:04:43 rakearun ship $
3 
4 FUNCTION get_message_1_token
5 (
6 	p_message			IN VARCHAR2,
7 	p_token1_name		IN VARCHAR2,
8 	p_token1_value		IN VARCHAR2
9 ) RETURN VARCHAR2;
10 
11 PROCEDURE process_spreadsheet_data
12 (
13 	p_batch_id		IN pon_bid_item_prices_interface.batch_id%TYPE,
14 	p_bid_number		IN pon_bid_headers.bid_number%TYPE,
15 	p_request_id		IN pon_bid_headers.request_id%TYPE,
16 	p_userid		IN pon_interface_errors.created_by%TYPE,
17 	x_return_status		OUT NOCOPY VARCHAR2,
18 	x_return_code		OUT NOCOPY VARCHAR2
19 );
20 
21 PROCEDURE process_xml_spreadsheet_data
22 (
23         p_batch_id              IN pon_bid_item_prices_interface.batch_id%TYPE,
24         p_bid_number            IN pon_bid_headers.bid_number%TYPE,
25         p_request_id            IN pon_bid_headers.request_id%TYPE,
26         p_user_id               IN pon_interface_errors.created_by%TYPE,
27         x_return_status         OUT NOCOPY NUMBER,
28         x_return_code           OUT NOCOPY VARCHAR2
29 );
30 
31 PROCEDURE remove_xml_skipped_lines
32 (
33 	p_auc_header_id		IN pon_bid_item_prices_interface.auction_header_id%TYPE,
34 	p_batch_id			IN pon_bid_item_prices_interface.batch_id%TYPE,
35 	p_request_id		IN pon_bid_headers.request_id%TYPE,
36 	p_userid			IN pon_interface_errors.created_by%TYPE,
37 	p_full_qty			IN VARCHAR2,
38 	p_buyer_user		IN VARCHAR2,
39 	p_suffix			IN VARCHAR2
40 ) ;
41 
42 PROCEDURE copy_shipment_interface_to_txn
43 (
44 	p_batch_id			IN pon_bid_item_prices_interface.batch_id%TYPE,
45 	p_bid_number		IN pon_bid_headers.bid_number%TYPE,
46 	p_userid			IN pon_bid_item_prices.last_updated_by%TYPE,
47     p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
48         p_shipment_type               IN pon_bid_shipments.shipment_type%TYPE
49 );
50 
51 --<Sol Project>
52 PROCEDURE process_spreadsheet_uda_data
53 (
54 	p_batch_id		IN pon_bid_item_prices_interface.batch_id%TYPE,
55 	--Bug 16654950
56     p_transaction_id		  IN  po_uda_interface.transaction_id%TYPE,
57 	p_bid_number		IN pon_bid_headers.bid_number%TYPE,
58 	p_request_id		IN pon_bid_headers.request_id%TYPE,
59 	p_userid		IN pon_interface_errors.created_by%TYPE,
60 	x_return_status		OUT NOCOPY VARCHAR2
61 );
62 END PON_RESPONSE_IMPORT_PKG;