1 PACKAGE PON_AUCTION_PO_PKG AUTHID CURRENT_USER as
2 /* $Header: PONAUPOS.pls 120.2.12020000.3 2013/02/09 08:50:49 hvutukur ship $ */
3
4
5 PROCEDURE GET_ATTACHMENT(pk1 IN NUMBER,
6 pk2 IN NUMBER,
7 pk3 IN NUMBER,
8 attachmentType IN VARCHAR2,
9 attachmentDesc OUT NOCOPY VARCHAR2,
10 attachment OUT NOCOPY LONG,
11 error_code OUT NOCOPY VARCHAR2,
12 error_msg OUT NOCOPY VARCHAR2);
13
14 PROCEDURE GET_ATTRIBUTE_ATTACHMENT(p_auction_header_id IN NUMBER,
15 p_bid_number IN NUMBER,
16 p_line_number IN NUMBER,
17 p_attachmentDesc OUT NOCOPY VARCHAR2,
18 p_attachment OUT NOCOPY LONG,
19 p_error_code OUT NOCOPY VARCHAR2,
20 p_error_msg OUT NOCOPY VARCHAR2);
21
22 PROCEDURE GET_HDR_ATTRIBUTE_ATTACHMENT(p_auction_header_id IN NUMBER,
23 p_bid_number IN NUMBER,
24 p_line_number IN NUMBER,
25 p_attachmentDesc OUT NOCOPY VARCHAR2,
26 p_attachment OUT NOCOPY LONG,
27 p_error_code OUT NOCOPY VARCHAR2,
28 p_error_msg OUT NOCOPY VARCHAR2);
29 PROCEDURE GET_HDR_ATTRIBUTE_ATTACH_CLOB(p_auction_header_id IN NUMBER,
30 p_bid_number IN NUMBER,
31 p_line_number IN NUMBER,
32 p_attachmentDesc OUT NOCOPY VARCHAR2,
33 p_attachment OUT NOCOPY CLOB,
34 p_error_code OUT NOCOPY VARCHAR2,
35 p_error_msg OUT NOCOPY VARCHAR2);
36
37 PROCEDURE GET_NOTE_TO_BUYER_ATTACHMENT(p_auction_header_id IN NUMBER,
38 p_bid_number IN NUMBER,
39 p_line_number IN NUMBER,
40 p_attachmentDesc OUT NOCOPY VARCHAR2,
41 p_attachment OUT NOCOPY LONG,
42 p_error_code OUT NOCOPY VARCHAR2,
43 p_error_msg OUT NOCOPY VARCHAR2);
44
45 PROCEDURE GET_NOTE_TO_SUPP_ATTACHMENT(p_auction_header_id IN NUMBER,
46 p_line_number IN NUMBER,
47 p_attachmentDesc OUT NOCOPY VARCHAR2,
48 p_attachment OUT NOCOPY LONG,
49 p_error_code OUT NOCOPY VARCHAR2,
50 p_error_msg OUT NOCOPY VARCHAR2,
51 p_line_or_header IN VARCHAR2);
52
53 PROCEDURE GET_TOTAL_COST_ATTACHMENT(p_auction_header_id IN NUMBER,
54 p_bid_number IN NUMBER,
55 p_line_number IN NUMBER,
56 p_attachmentDesc OUT NOCOPY VARCHAR2,
57 p_attachment OUT NOCOPY LONG,
58 p_error_code OUT NOCOPY VARCHAR2,
59 p_error_msg OUT NOCOPY VARCHAR2);
60
61 PROCEDURE check_unique(org_id IN NUMBER,
62 po_number IN VARCHAR2,
63 status OUT NOCOPY VARCHAR2);
64
65 /*-----------------------------------------------------------------
66 * check_unique: This procedure will check for the uniquesness of
67 * the po_number in pon_bid_headers table for a given org_id,po_number
68 * and bid_number.
69 *----------------------------------------------------------------*/
70
71 PROCEDURE check_unique(org_id IN NUMBER,
72 po_number IN VARCHAR2,
73 p_bid_number IN NUMBER,
74 status OUT NOCOPY VARCHAR2);
75
76 PROCEDURE GET_JOB_DETAILS_ATTACHMENT (p_auction_header_id IN NUMBER,
77 p_line_number IN NUMBER,
78 p_attachmentDesc OUT NOCOPY VARCHAR2,
79 p_attachment OUT NOCOPY LONG,
80 p_error_code OUT NOCOPY VARCHAR2,
81 p_error_msg OUT NOCOPY VARCHAR2);
82
83 --Complex work- This method creates fnd attachments out of Buyer notes on Payments
84 PROCEDURE GET_PAYMENT_NOTE_TO_SUPP ( p_auction_payment_id IN NUMBER,
85 p_attachmentDesc OUT NOCOPY VARCHAR2,
86 p_attachment OUT NOCOPY LONG,
87 p_error_code OUT NOCOPY VARCHAR2,
88 p_error_msg OUT NOCOPY VARCHAR2);
89
90
91 END PON_AUCTION_PO_PKG;