1 PACKAGE PO_SYNC_DRAFT_FROM_ARCHIVE_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_SYNC_DRAFT_FROM_ARCHIVE_PVT.pls 120.0.12020000.2 2013/02/11 00:35:12 vegajula ship $ */
3
4 -------------------------------------------------------------------------------
5 --Start of Comments
6 --Name: SYNC_DRAFT_FROM_ARCHIVE
7 --Pre-reqs:
8 -- None.
9 --Modifies:
10 -- None.
11 --Locks:
12 -- None.
13 --Function:
14 -- Copy data from Archive table to draft table, if the corresponding
15 -- record in draft table does not exist.
16 -- This is done to handle the View Base Document.
17 --Parameters:
18 --IN:
19 --p_document_id
20 -- The id of the document that needs to be handled for View Base Document.
21 --p_document_type
22 -- The type of the document to sync
23 -- PO : For Standard/Planned
24 -- PA : For Blanket/Contract
25 --p_document_subtype
26 -- The subtype of the document.
27 -- Valid Document types and Document subtypes are
28 -- Document Type Document Subtype
29 -- PO ---> STANDARD
30 -- PA ---> CONTRACT/BLANKET
31 --p_revision_num
32 -- The version of the document that is being handled for View Base Document
33 -- In the current scope of the project, this is always 0, corr. to the base doc
34 --p_draft_id
35 -- The draft_id using which the record has to be inserted at the time of sync
36 -- In the current scope of the project, this is always 0, corr. to the base doc
37 --OUT:
38 --x_return_status
39 -- FND_API.G_RET_STS_SUCCESS if API succeeds
40 -- FND_API.G_RET_STS_ERROR if API fails
41 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
42 --x_msg_count
43 -- returns count of messages in the stack.
44 --x_msg_data
45 -- Contains error msg in case x_return_status returned
46 -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
47 --Testing:
48 -- None.
49 --End of Comments
50 -------------------------------------------------------------------------------
51 PROCEDURE SYNC_DRAFT_FROM_ARCHIVE(p_document_id IN NUMBER,
52 p_document_type IN VARCHAR2,
53 p_document_subtype IN VARCHAR2,
54 p_revision_num IN NUMBER DEFAULT 0,
55 p_draft_id IN NUMBER DEFAULT 0,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 END PO_SYNC_DRAFT_FROM_ARCHIVE_PVT; -- Package spec