30: PROCEDURE validate_bid
31: (
32: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
33: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
34: p_interface_type IN pon_interface_errors.interface_type%TYPE,
35: p_userid IN pon_interface_errors.created_by%TYPE,
36: p_batch_id IN pon_interface_errors.batch_id%TYPE,
37: p_request_id IN pon_interface_errors.request_id%TYPE,
38: x_return_status OUT NOCOPY NUMBER,
31: (
32: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
33: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
34: p_interface_type IN pon_interface_errors.interface_type%TYPE,
35: p_userid IN pon_interface_errors.created_by%TYPE,
36: p_batch_id IN pon_interface_errors.batch_id%TYPE,
37: p_request_id IN pon_interface_errors.request_id%TYPE,
38: x_return_status OUT NOCOPY NUMBER,
39: x_return_code OUT NOCOPY VARCHAR2
32: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
33: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
34: p_interface_type IN pon_interface_errors.interface_type%TYPE,
35: p_userid IN pon_interface_errors.created_by%TYPE,
36: p_batch_id IN pon_interface_errors.batch_id%TYPE,
37: p_request_id IN pon_interface_errors.request_id%TYPE,
38: x_return_status OUT NOCOPY NUMBER,
39: x_return_code OUT NOCOPY VARCHAR2
40: );
33: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
34: p_interface_type IN pon_interface_errors.interface_type%TYPE,
35: p_userid IN pon_interface_errors.created_by%TYPE,
36: p_batch_id IN pon_interface_errors.batch_id%TYPE,
37: p_request_id IN pon_interface_errors.request_id%TYPE,
38: x_return_status OUT NOCOPY NUMBER,
39: x_return_code OUT NOCOPY VARCHAR2
40: );
41:
42: PROCEDURE validate_spreadsheet_upload
43: (
44: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
45: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
46: p_interface_type IN pon_interface_errors.interface_type%TYPE,
47: p_spreadsheet_type IN VARCHAR2,
48: p_userid IN pon_interface_errors.created_by%TYPE,
49: p_batch_id IN pon_interface_errors.batch_id%TYPE,
50: p_request_id IN pon_interface_errors.request_id%TYPE,
44: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
45: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
46: p_interface_type IN pon_interface_errors.interface_type%TYPE,
47: p_spreadsheet_type IN VARCHAR2,
48: p_userid IN pon_interface_errors.created_by%TYPE,
49: p_batch_id IN pon_interface_errors.batch_id%TYPE,
50: p_request_id IN pon_interface_errors.request_id%TYPE,
51: x_return_status OUT NOCOPY NUMBER,
52: x_return_code OUT NOCOPY VARCHAR2
45: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
46: p_interface_type IN pon_interface_errors.interface_type%TYPE,
47: p_spreadsheet_type IN VARCHAR2,
48: p_userid IN pon_interface_errors.created_by%TYPE,
49: p_batch_id IN pon_interface_errors.batch_id%TYPE,
50: p_request_id IN pon_interface_errors.request_id%TYPE,
51: x_return_status OUT NOCOPY NUMBER,
52: x_return_code OUT NOCOPY VARCHAR2
53: );
46: p_interface_type IN pon_interface_errors.interface_type%TYPE,
47: p_spreadsheet_type IN VARCHAR2,
48: p_userid IN pon_interface_errors.created_by%TYPE,
49: p_batch_id IN pon_interface_errors.batch_id%TYPE,
50: p_request_id IN pon_interface_errors.request_id%TYPE,
51: x_return_status OUT NOCOPY NUMBER,
52: x_return_code OUT NOCOPY VARCHAR2
53: );
54: