28: ) RETURN VARCHAR2;
29:
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,
29:
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,
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,
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,
53: );
54:
55: PROCEDURE populate_has_bid_changed_line
56: (
57: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
58: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
59: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
60: p_batch_start IN NUMBER,
61: p_batch_end IN NUMBER,
54:
55: PROCEDURE populate_has_bid_changed_line
56: (
57: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
58: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
59: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
60: p_batch_start IN NUMBER,
61: p_batch_end IN NUMBER,
62: p_rebid_flag IN VARCHAR2,
55: PROCEDURE populate_has_bid_changed_line
56: (
57: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
58: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
59: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
60: p_batch_start IN NUMBER,
61: p_batch_end IN NUMBER,
62: p_rebid_flag IN VARCHAR2,
63: p_blanket IN VARCHAR2,