1 PACKAGE PO_SOURCING_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVCPAS.pls 120.0 2005/06/02 02:16:24 appldev noship $*/
3
4 ---
5 --- +=======================================================================+
6 --- | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
7 --- | All rights reserved. |
8 --- +=======================================================================+
9 --- |
10 --- | FILENAME
11 --- | POXVCPAS.pls
12 --- |
13 --- |
14 --- | DESCRIPTION
15 --- |
16 --- | This package contains procedures called from the sourcing
17 --- | to create CPA in PO
18 --- |
19 --- | HISTORY
20 --- |
21 --- | 30-Sep-2004 rbairraj Initial version
22 --- |
23 --- +=======================================================================+
24 ---
25
26 --------------------------------------------------------------------------------
27
28 -------------------------------------------------------------------------------
29 --Start of Comments
30 --Name: create_cpa
31 --Pre-reqs:
32 -- None
33 --Modifies:
34 -- Transaction tables for the requested document
35 --Locks:
36 -- None.
37 --Function:
38 -- Creates Contract Purchase Agreement from Sourcing document
39 --Parameters:
40 --IN:
41 --p_interface_header_id
42 -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
43 --p_auction_header_id
44 -- Id of the negotiation
45 --p_bid_number
46 -- Bid Number for which is negotiation is awarded
47 --p_sourcing_k_doc_type
48 -- Represents the OKC document type that would be created into a CPA
49 -- The document type that Sourcing has seeded in Contracts.
50 --p_conterms_exist_flag
51 -- Whether the sourcing document has contract template attached.
52 --p_document_creation_method
53 -- Column specific to DBI. Sourcing will pass a value of AWARD_SOURCING
54 --OUT:
55 --x_document_id
56 -- The unique identifier for the newly created document.
57 --x_document_number
58 -- The document number that would uniquely identify a document in a given organization.
59 --x_return_status
60 -- The standard OUT parameter giving return status of the API call.
61 -- FND_API.G_RET_STS_ERROR - for expected error
62 -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
63 -- FND_API.G_RET_STS_SUCCESS - for success
64 --Notes:
65 -- None
66 --Testing:
67 -- None
68 --End of Comments
69 -------------------------------------------------------------------------------
70 PROCEDURE create_cpa (
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE,
75 p_auction_header_id IN PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE,
76 p_bid_number IN PON_BID_HEADERS.bid_number%TYPE,
77 p_sourcing_k_doc_type IN VARCHAR2,
78 p_conterms_exist_flag IN PO_HEADERS_ALL.conterms_exist_flag%TYPE,
79 p_document_creation_method IN PO_HEADERS_ALL.document_creation_method%TYPE,
80 x_document_id OUT NOCOPY PO_HEADERS_ALL.po_header_id%TYPE,
81 x_document_number OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE
82 );
83
84 -------------------------------------------------------------------------------
85 --Start of Comments
86 --Name: DELETE_INTERFACE_HEADER
87 --Pre-reqs:
88 -- None
89 --Modifies:
90 -- po_headers_interface
91 --Locks:
92 -- None.
93 --Function:
94 -- This deletes the interface header row from interface table
95 --Parameters:
96 --IN:
97 --p_interface_header_id
98 -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
99 --OUT:
100 --x_return_status
101 -- The standard OUT parameter giving return status of the API call.
102 -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
103 -- FND_API.G_RET_STS_SUCCESS - for success
104 --Notes:
105 -- None
106 --Testing:
107 -- None
108 --End of Comments
109 -------------------------------------------------------------------------------
110
111 PROCEDURE DELETE_INTERFACE_HEADER (
112 p_interface_header_id IN PO_HEADERS_INTERFACE.INTERFACE_HEADER_ID%TYPE,
113 x_return_status OUT NOCOPY VARCHAR2
114 );
115
116 END PO_SOURCING_PVT;