1 PACKAGE PON_NEG_UPDATE_PKG as
2 /* $Header: PONUPDTS.pls 120.5 2007/05/25 16:21:40 mshujath ship $ */
3
4
5 PROCEDURE MANUAL_CLOSE (p_auction_header_id IN NUMBER,
6 p_close_now_flag IN VARCHAR2,
7 p_new_close_date IN DATE,
8 p_reason IN VARCHAR2,
9 p_user_id IN NUMBER) ;
10
11 PROCEDURE CANCEL_NEGOTIATION (p_auction_header_id IN NUMBER,
12 p_send_note_flag IN VARCHAR2,
13 p_reason IN VARCHAR2,
14 p_user_id IN NUMBER,
15 x_error_code OUT NOCOPY VARCHAR2) ;
16
17 PROCEDURE MANUAL_EXTEND (p_auction_header_id IN NUMBER,
18 p_close_date IN DATE,
19 p_new_close_date IN DATE,
20 p_is_autoExtend IN VARCHAR2,
21 p_new_autoextend_num IN NUMBER,
22 p_is_allExtend IN VARCHAR2,
23 p_new_duration IN NUMBER,
24 p_new_extend_type IN VARCHAR2,
25 p_user_id IN NUMBER,
26 p_last_updated_date IN DATE,
27 p_auto_extend_min_trigger IN NUMBER,
28 p_result OUT NOCOPY NUMBER,
29 p_extended_close_bidding_date OUT NOCOPY DATE );
30
31 PROCEDURE ACTIVATE_PREV_ROUND_NEG (p_prev_round_auction_header_id IN NUMBER);
32
33 PROCEDURE CAN_EDIT_DRAFT_AMEND (p_auction_header_id_prev_doc IN NUMBER,
34 x_error_code OUT NOCOPY VARCHAR2);
35
36 PROCEDURE UPDATE_TO_NEW_DOCUMENT (p_auction_header_id_curr_doc IN NUMBER,
37 p_doc_number_curr_doc IN VARCHAR2,
38 p_auction_header_id_prev_doc IN NUMBER,
39 p_auction_origination_code IN VARCHAR2,
40 p_is_new IN VARCHAR2,
41 p_is_publish IN VARCHAR2,
42 p_transaction_type IN VARCHAR2,
43 p_user_id IN NUMBER,
44 x_error_code OUT NOCOPY VARCHAR2,
45 x_error_msg OUT NOCOPY VARCHAR2);
46
47 PROCEDURE UPDATE_MODIFIED_FIELDS (p_currAuctionHeaderId IN NUMBER,
48 p_prevAuctionHeaderId IN NUMBER,
49 p_action IN VARCHAR2);
50
51 PROCEDURE UPDATE_CURRENCY_RATES_MODIFIED (p_currAuctionHeaderId IN NUMBER,
52 p_prevAuctionHeaderId IN NUMBER,
53 p_action IN VARCHAR2);
54
55 PROCEDURE UPDATE_NEG_TEAM_MODIFIED (p_currAuctionHeaderId IN NUMBER,
56 p_prevAuctionHeaderId IN NUMBER,
57 p_action IN VARCHAR2);
58
59 PROCEDURE UPDATE_INVITEES_MODIFIED (p_currAuctionHeaderId IN NUMBER,
60 p_prevAuctionHeaderId IN NUMBER,
61 p_action IN VARCHAR2);
62
63 PROCEDURE UPDATE_HDR_ATTR_MODIFIED (p_currAuctionHeaderId IN NUMBER,
64 p_prevAuctionHeaderId IN NUMBER,
65 p_action IN VARCHAR2);
66
67 PROCEDURE PROPAGATE_BACK_INSERT_INVITEE(p_currAuctionHeaderId IN NUMBER,
68 p_sequence IN NUMBER);
69
70 PROCEDURE PROPAGATE_BACK_UPDATE_INVITEE(p_currAuctionHeaderId IN NUMBER,
71 p_sequence IN NUMBER);
72
73 PROCEDURE PROPAGATE_BACK_INSERT_MEMBER(p_currAuctionHeaderId IN NUMBER,
74 p_userId IN NUMBER);
75
76 PROCEDURE PROPAGATE_BACK_UNLOCK(p_currAuctionHeaderId IN NUMBER,
77 p_userId IN NUMBER,
78 p_unlock_date IN DATE,
79 p_unlock_type IN VARCHAR2);
80
81 PROCEDURE PROPAGATE_BACK_UNSEAL(p_currAuctionHeaderId IN NUMBER,
82 p_userId IN NUMBER,
83 p_unseal_date IN DATE,
84 p_unseal_type IN VARCHAR2);
85
86
87 PROCEDURE PROCESS_PRICE_FACTORS(p_auction_header_id IN NUMBER,
88 p_user_id IN NUMBER,
89 p_login_id IN NUMBER);
90
91 PROCEDURE MANUAL_CLOSE_LINE (x_result OUT NOCOPY VARCHAR2, --1
92 x_error_code OUT NOCOPY VARCHAR2, --2
93 x_error_message OUT NOCOPY VARCHAR2, --3
94 p_auction_header_id IN NUMBER, --4
95 p_line_number IN NUMBER, --5
96 p_user_id IN NUMBER, --6
97 x_is_auction_closed OUT NOCOPY VARCHAR2); --7
98
99 PROCEDURE PROPAGATE_BACK_TECH_EVAL(p_currAuctionHeaderId IN NUMBER,
100 p_tech_eval_status IN VARCHAR2);
101
102 END PON_NEG_UPDATE_PKG;