1 PACKAGE PON_RESPONSE_PVT AUTHID CURRENT_USER AS
2 -- $Header: PONRESPS.pls 120.10 2010/11/17 02:40:53 atjen ship $
3
4 FUNCTION get_header_close_bidding_date
5 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE)
6 RETURN DATE;
7
8 FUNCTION get_line_close_bidding_date
9 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
10 p_line_number IN pon_bid_item_prices.line_number%TYPE,
11 p_is_paused IN pon_auction_headers_all.is_paused%TYPE,
12 p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)
13 RETURN DATE;
14
15 PROCEDURE calculate_group_amounts
16 (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
17 p_line_number IN pon_bid_item_prices.line_number%TYPE,
18 p_is_supplier IN VARCHAR,
19 p_group_amount OUT NOCOPY NUMBER);
20
21 PROCEDURE calculate_group_amounts
22 (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
23 p_is_supplier IN VARCHAR);
24
25 PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
26 p_is_supplier IN VARCHAR,
27 p_do_all_lines IN VARCHAR,
28 p_batch_id IN pon_bid_item_prices.batch_id%TYPE);
29
30 PROCEDURE calculate_group_amounts_auto
31 (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
32 p_is_supplier IN VARCHAR);
33
34 PROCEDURE change_bid_by_percentage
35 (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
36 p_power_percentage IN NUMBER,
37 p_powerbidlosinglines IN VARCHAR2,
38 p_previous_bid_number IN pon_bid_headers.old_bid_number%TYPE);
39
40
41 PROCEDURE recalculate_auc_curr_prices
42 (
43 p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
44 p_curr_changed IN VARCHAR2,
45 p_batch_id IN pon_bid_item_prices.batch_id%TYPE
46 );
47
48 PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
49 p_bid_number IN pon_bid_headers.bid_number%TYPE,
50 p_rebid_flag IN VARCHAR,
51 p_publish_date IN pon_bid_headers.publish_date%TYPE,
52 p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
53 p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
54 p_user_id IN NUMBER,
55 p_batch_id IN NUMBER,
56 p_request_id IN NUMBER,
57 p_hdr_validation_failed IN VARCHAR,
58 x_return_status OUT NOCOPY NUMBER,
59 x_return_code OUT NOCOPY VARCHAR);
60
61
62 PROCEDURE remove_empty_rows
63 (p_bid_number IN pon_bid_headers.bid_number%TYPE,
64 p_batch_start IN NUMBER,
65 p_batch_end IN NUMBER);
66
67 PROCEDURE remove_empty_rows_auto
68 (p_bid_number IN pon_bid_headers.bid_number%TYPE,
69 p_max_line_number IN NUMBER,
70 p_batch_size IN NUMBER);
71
72 PROCEDURE update_bid_header_fields
73 (p_bid_number IN pon_bid_headers.bid_number%TYPE,
74 p_publish_date IN pon_bid_headers.publish_date%TYPE,
75 p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
76 p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
77 p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
78 p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE);
79
80 PROCEDURE update_bid_header_fields_auto
81 (p_bid_number IN pon_bid_headers.bid_number%TYPE,
82 p_publish_date IN pon_bid_headers.publish_date%TYPE,
83 p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
84 p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
85 p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
86 p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE);
87
88 PROCEDURE publish_lines
89 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
90 p_bid_number IN pon_bid_headers.bid_number%TYPE,
91 p_publish_date IN DATE,
92 p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
93 p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
94 p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
95 p_rebid_flag IN VARCHAR,
96 p_batch_start IN NUMBER,
97 p_batch_end IN NUMBER);
98
99 PROCEDURE publish_lines_auto
100 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
101 p_bid_number IN pon_bid_headers.bid_number%TYPE,
102 p_publish_date IN DATE,
103 p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
104 p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
105 p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
106 p_rebid_flag IN VARCHAR,
107 p_max_line_number IN NUMBER,
108 p_batch_size IN NUMBER);
109
110
111 PROCEDURE publish_cp
112 (errbuf OUT NOCOPY VARCHAR2,
113 retcode OUT NOCOPY VARCHAR2,
114 p_auction_header_id IN NUMBER,
115 p_bid_number IN NUMBER,
116 p_rebid_flag IN VARCHAR2,
117 p_publish_date IN VARCHAR2,
118 p_date_mask IN VARCHAR2,
119 p_tp_id IN NUMBER,
120 p_tpc_id IN NUMBER,
121 p_user_type IN VARCHAR2,
122 p_user_id IN NUMBER);
123
124 PROCEDURE validate_cp
125 (errbuf OUT NOCOPY VARCHAR2,
126 retcode OUT NOCOPY VARCHAR2,
127 p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
128 p_bid_number IN pon_bid_headers.bid_number%TYPE,
129 p_user_type IN VARCHAR2,
130 p_user_id IN NUMBER);
131
132 PROCEDURE get_message_name(p_msg_code IN VARCHAR2,
133 p_auction_header_id IN NUMBER,
134 x_msg_name OUT NOCOPY VARCHAR2);
135
136 PROCEDURE get_user_lang_message (p_tpc_id IN NUMBER,
137 p_message_name IN VARCHAR2,
138 p_message_token1_name IN VARCHAR2,
139 p_message_token1_value IN VARCHAR2,
140 p_message_token2_name IN VARCHAR2,
141 p_message_token2_value IN VARCHAR2,
142 x_message_text OUT NOCOPY VARCHAR2);
143
144 --CLM Mark Info Lines
145 PROCEDURE MARK_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE);
146 PROCEDURE MARK_OPTION_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE);
147
148 -- Begin Supplier Management: Supplier Evaluation
149
150 -- Procedure to calculate the average evaluation scores for each supplier,
151 -- and put the scores into each supplier response.
152
153 PROCEDURE calculate_avg_eval_scores(p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE);
154
155 -- End Supplier Management: Supplier Evaluation
156
157 END PON_RESPONSE_PVT;