eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_RESPONSE_PVT dependencies on PON_BID_HEADERS

Line 5: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE)

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,

Line 9: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

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;

Line 38: p_previous_bid_number IN pon_bid_headers.old_bid_number%TYPE);

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: (

Line 48: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%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,

Line 49: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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,

Line 51: p_publish_date IN pon_bid_headers.publish_date%TYPE,

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,

Line 52: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

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,

Line 53: p_tpc_id IN pon_bid_headers.trading_partner_contact_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,

Line 63: (p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

Line 68: (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

Line 73: (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,

Line 74: p_publish_date IN pon_bid_headers.publish_date%TYPE,

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);

Line 75: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,

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:

Line 76: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

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

Line 81: (p_bid_number IN pon_bid_headers.bid_number%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,

Line 82: p_publish_date IN pon_bid_headers.publish_date%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);

Line 83: p_bid_entry_date IN pon_bid_headers.publish_date%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:

Line 84: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

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

Line 89: (p_auction_header_id IN pon_bid_headers.auction_header_id%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,

Line 90: p_bid_number IN pon_bid_headers.bid_number%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,

Line 92: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

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,

Line 94: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%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:

Line 100: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

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,

Line 101: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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,

Line 103: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

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,

Line 105: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%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:

Line 127: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

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:

Line 128: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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,

Line 145: PROCEDURE MARK_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE);

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:

Line 146: PROCEDURE MARK_OPTION_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE);

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,