1 PACKAGE pon_sourcing_openapi_grp AUTHID CURRENT_USER AS
2 /* $Header: PONRNBAS.pls 120.6 2009/09/12 09:35:35 ssreekum ship $ */
3
4 g_header_rec pon_auc_headers_interface%ROWTYPE;
5
6 PROCEDURE create_draft_neg_interface (p_interface_id NUMBER,
7 x_document_number OUT NOCOPY NUMBER,
8 x_document_url OUT NOCOPY VARCHAR2,
9 x_result OUT NOCOPY VARCHAR2,
10 x_error_code OUT NOCOPY VARCHAR2,
11 x_error_message OUT NOCOPY VARCHAR2);
12
13 PROCEDURE create_draft_neg_interface (p_interface_id NUMBER,
14 x_document_number OUT NOCOPY NUMBER,
15 x_document_url OUT NOCOPY VARCHAR2,
16 x_concurrent_program_started OUT NOCOPY VARCHAR2,
17 x_request_id OUT NOCOPY NUMBER,
18 x_result OUT NOCOPY VARCHAR2,
19 x_error_code OUT NOCOPY VARCHAR2,
20 x_error_message OUT NOCOPY VARCHAR2);
21
22 PROCEDURE val_auc_headers_interface(p_interface_id NUMBER,
23 x_error_code OUT NOCOPY VARCHAR2,
24 x_error_message OUT NOCOPY VARCHAR2);
25
26 PROCEDURE val_auc_items_interface(p_interface_id NUMBER,
27 x_error_code OUT NOCOPY VARCHAR2,
28 x_error_message OUT NOCOPY VARCHAR2);
29
30 PROCEDURE val_auc_shipments_interface(p_interface_id NUMBER,
31 x_error_code OUT NOCOPY VARCHAR2,
32 x_error_message OUT NOCOPY VARCHAR2);
33
34 PROCEDURE val_attachments_interface(p_interface_id NUMBER,
35 x_error_code OUT NOCOPY VARCHAR2,
36 x_error_message OUT NOCOPY VARCHAR2);
37
38 PROCEDURE get_trading_partner_info (p_vendor_id NUMBER,
39 x_trading_partner_id OUT NOCOPY NUMBER,
40 x_trading_partner_name OUT NOCOPY VARCHAR2,
41 x_trading_partner_contact_id OUT NOCOPY VARCHAR2,
42 x_trading_partner_contact_name OUT NOCOPY VARCHAR2,
43 x_error_code OUT NOCOPY VARCHAR2,
44 x_error_message OUT NOCOPY varchar2);
45
46 PROCEDURE purge_interface_table(p_interface_id IN NUMBER,
47 x_result OUT NOCOPY VARCHAR2,
48 x_error_code OUT NOCOPY VARCHAR2,
49 x_error_message OUT NOCOPY VARCHAR2
50 );
51
52 -------------------------------------------------------------------------------
53 -- This procedure determines if CPA outcome from rfq feature is enabled or not.
54 -- x_cpa_enabled
55 -- Y if creation of CPA from sourcing is enabled
56 -- N if creation of CPA from sourcing is disabled.
57 -------------------------------------------------------------------------------
58
59 PROCEDURE is_cpa_integration_enabled
60 (p_api_version IN VARCHAR2
61 ,p_init_msg_list IN VARCHAR2
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65 ,x_cpa_enabled OUT NOCOPY VARCHAR2);
66
67 PROCEDURE get_display_line_number(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2,
70 p_auction_header_id IN NUMBER,
71 p_auction_line_number IN NUMBER,
72 x_display_line_number OUT NOCOPY VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2);
76
77
78 --PROCEDURE FOR RENEGOTIATING SUPER LARGE NEGOTIATIONS
79 --This procedure will be called by the concurrent
80 --manager. This inturn calls the create_draft_neg_interface_pvt
81 --procedure with p_is_conc_call = 'Y'
82
83
84 PROCEDURE PON_RENEG_SUPER_LARGE_NEG (
85 EFFBUF OUT NOCOPY VARCHAR2,
86 RETCODE OUT NOCOPY VARCHAR2,
87 p_interface_id IN NUMBER,
88 p_auction_header_id IN NUMBER,
89 p_user_name IN VARCHAR2);
90
91
92
93 /*===================================================================
94 PROCEDURE: maintain_clm_relations PUBLIC
95 PARAMETERS:
96 p_interface_id IN NUMBER, -- Interface id
97 x_result OUT NOCOPY VARCHAR2,
98 x_error_code OUT NOCOPY VARCHAR2,
99 x_error_message OUT NOCOPY VARCHAR2
100
101 COMMENT: -- After the lines have been autocreated. Set the CLM clin slin and option relations appropriately.
102 -- Currently the reqline ids have been copied over as it is.
103 -- Now map the correct reqlineids with the neg line numbers and store
104 -- in the negotiation lines table.
105
106 =====================================================================*/
107 PROCEDURE maintain_clm_relations(
108 p_interface_id IN NUMBER,
109 x_result OUT NOCOPY VARCHAR2,
110 x_error_code OUT NOCOPY VARCHAR2,
111 x_error_message OUT NOCOPY VARCHAR2
112 );
113
114 END PON_SOURCING_OPENAPI_GRP;