1 PACKAGE PON_UDA_PKG AUTHID CURRENT_USER AS
2 /* $Header: PON_UDA_PKG.pls 120.11 2010/07/15 13:38:13 irasoolm noship $*/
3
4 procedure competitive_info_XDE(x_set_aside_status OUT NOCOPY VARCHAR2,
5 x_set_aside_per OUT NOCOPY VARCHAR2);
6
7 PROCEDURE pon_add_item_info_XLE(p_item_id IN NUMBER,
8 p_org_id IN NUMBER,
9 x_ext_description OUT NOCOPY VARCHAR,
10 x_return_status OUT NOCOPY VARCHAR,
11 x_errorcode OUT NOCOPY VARCHAR,
12 x_msg_count OUT NOCOPY VARCHAR,
13 x_msg_data OUT NOCOPY VARCHAR);
14
15
16 PROCEDURE pon_addressdef (
17 addresstype IN OUT nocopy VARCHAR2
18 ,location IN OUT nocopy NUMBER
19 ,addresscode IN OUT nocopy NUMBER
20 ,contact IN OUT nocopy NUMBER
21 ,addressdetails IN OUT nocopy VARCHAR2
22 ,contactdetails IN OUT nocopy VARCHAR2
23 ,addressdetailsxml IN OUT nocopy VARCHAR2
24 ,contactdetailsxml IN OUT nocopy VARCHAR2
25 , hiddenCountry IN OUT nocopy VARCHAR2
26 , hiddenZipCode IN OUT nocopy VARCHAR2
27 ,HiddenAddType IN VARCHAR2
28 ,HiddenLKPType IN VARCHAR2);
29
30 PROCEDURE pon_addresses_XPD(p_header_id IN NUMBER,
31 p_HiddenAddType IN VARCHAR2,
32 p_HiddenLKPType IN VARCHAR2,
33 x_location IN OUT NOCOPY NUMBER,
34 x_addresscode IN OUT NOCOPY NUMBER,
35 x_contact_id IN OUT NOCOPY NUMBER,
36 x_addressdetails IN OUT NOCOPY VARCHAR2,
37 x_contactdetails IN OUT NOCOPY VARCHAR2,
38 x_addressdtlsxml IN OUT NOCOPY VARCHAR2,
39 x_contactdtlsxml IN OUT NOCOPY VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_errorcode OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY VARCHAR2,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 PROCEDURE delete_uda(p_auction_header_id IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_error_msg OUT NOCOPY VARCHAR2);
48
49 PROCEDURE DEFAULT_NON_RENDER_UDA( p_auction_header_id IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE IMPORT_EXCEL_UDA(p_bid_number IN NUMBER,
53 p_line_number IN NUMBER,
54 p_template_id IN NUMBER,
55 x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE,
56 x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE,
57 x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE,
58 x_total_amount OUT NOCOPY NUMBER,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_errorcode OUT NOCOPY NUMBER,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64 PROCEDURE VALIDATE_UDA(p_bid_number IN NUMBER,
65 p_line_number IN NUMBER,
66 p_template_id IN NUMBER,
67 p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE,
68 p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_errorcode OUT NOCOPY NUMBER,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 end PON_UDA_PKG;
75