1 PACKAGE OKC_CONTRACT_DOCS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVCONTRACTDOCS.pls 120.1 2006/02/21 16:15:53 vamuru noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_business_document_type IN VARCHAR2,
13 p_business_document_id IN NUMBER,
14 p_business_document_version IN NUMBER,
15 p_attached_document_id IN NUMBER,
16 p_external_visibility_flag IN VARCHAR2,
17 p_effective_from_type IN VARCHAR2,
18 p_effective_from_id IN NUMBER,
19 p_effective_from_version IN NUMBER,
20 p_include_for_approval_flag IN VARCHAR2,
21 p_program_id IN NUMBER,
22 p_program_application_id IN NUMBER,
23 p_request_id IN NUMBER,
24 p_program_update_date IN DATE,
25 p_parent_attached_doc_id IN NUMBER,
26 p_delete_flag IN VARCHAR2,
27 p_generated_flag IN VARCHAR2,
28
29 p_primary_contract_doc_flag IN VARCHAR2 := 'N',
30 p_mergeable_doc_flag IN VARCHAR2 := 'N',
31
32 x_business_document_type OUT NOCOPY VARCHAR2,
33 x_business_document_id OUT NOCOPY NUMBER,
34 x_business_document_version OUT NOCOPY NUMBER,
35 x_attached_document_id OUT NOCOPY NUMBER
36 );
37
38 PROCEDURE lock_row(
39 x_return_status OUT NOCOPY VARCHAR2,
40
41 p_business_document_type IN VARCHAR2,
42 p_business_document_id IN NUMBER,
43 p_business_document_version IN NUMBER,
44 p_attached_document_id IN NUMBER,
45
46 p_object_version_number IN NUMBER
47 );
48
49 PROCEDURE update_row(
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 x_return_status OUT NOCOPY VARCHAR2,
52
53 p_business_document_type IN VARCHAR2,
54 p_business_document_id IN NUMBER,
55 p_business_document_version IN NUMBER,
56 p_attached_document_id IN NUMBER,
57
58 p_external_visibility_flag IN VARCHAR2 := NULL,
59 p_effective_from_type IN VARCHAR2 := NULL,
60 p_effective_from_id IN NUMBER := NULL,
61 p_effective_from_version IN NUMBER := NULL,
62 p_include_for_approval_flag IN VARCHAR2 := NULL,
63 p_program_id IN NUMBER := NULL,
64 p_program_application_id IN NUMBER := NULL,
65 p_request_id IN NUMBER := NULL,
66 p_program_update_date IN DATE := NULL,
67 p_parent_attached_doc_id IN NUMBER := NULL,
68 p_delete_flag IN VARCHAR2 := NULL,
69 p_generated_flag IN VARCHAR2 := NULL,
70
71 p_primary_contract_doc_flag IN VARCHAR2 :=NULL,
72 p_mergeable_doc_flag IN VARCHAR2 :=NULL,
73
74 p_object_version_number IN NUMBER
75 );
76
77 PROCEDURE delete_row(
78 x_return_status OUT NOCOPY VARCHAR2,
79
80 p_business_document_type IN VARCHAR2,
81 p_business_document_id IN NUMBER,
82 p_business_document_version IN NUMBER,
83 p_attached_document_id IN NUMBER,
84
85 p_object_version_number IN NUMBER
86 );
87
88 PROCEDURE validate_row(
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 x_return_status OUT NOCOPY VARCHAR2,
91
92 p_business_document_type IN VARCHAR2,
93 p_business_document_id IN NUMBER,
94 p_business_document_version IN NUMBER,
95 p_attached_document_id IN NUMBER,
96 p_external_visibility_flag IN VARCHAR2,
97 p_effective_from_type IN VARCHAR2,
98 p_effective_from_id IN NUMBER,
99 p_effective_from_version IN NUMBER,
100 p_include_for_approval_flag IN VARCHAR2,
101 p_program_id IN NUMBER,
102 p_program_application_id IN NUMBER,
103 p_request_id IN NUMBER,
104 p_program_update_date IN DATE,
105 p_parent_attached_doc_id IN NUMBER,
106 p_delete_flag IN VARCHAR2,
107 p_generated_flag IN VARCHAR2,
108
109 p_primary_contract_doc_flag IN VARCHAR2 := 'N',
110 p_mergeable_doc_flag IN VARCHAR2 := 'N',
111
112 p_object_version_number IN NUMBER
113 );
114
115 FUNCTION get_rec (
116 p_business_document_type IN VARCHAR2,
117 p_business_document_id IN NUMBER,
118 p_business_document_version IN NUMBER,
119 p_attached_document_id IN NUMBER,
120
121 x_external_visibility_flag OUT NOCOPY VARCHAR2,
122 x_effective_from_type OUT NOCOPY VARCHAR2,
123 x_effective_from_id OUT NOCOPY NUMBER,
124 x_effective_from_version OUT NOCOPY NUMBER,
125 x_include_for_approval_flag OUT NOCOPY VARCHAR2,
126 x_program_id OUT NOCOPY NUMBER,
127 x_program_application_id OUT NOCOPY NUMBER,
128 x_request_id OUT NOCOPY NUMBER,
129 x_program_update_date OUT NOCOPY DATE,
130 x_parent_attached_doc_id OUT NOCOPY NUMBER,
131 x_delete_flag OUT NOCOPY VARCHAR2,
132 x_generated_flag OUT NOCOPY VARCHAR2,
133 x_object_version_number OUT NOCOPY NUMBER,
134 x_created_by OUT NOCOPY NUMBER,
135 x_creation_date OUT NOCOPY DATE,
136 x_last_updated_by OUT NOCOPY NUMBER,
137 x_last_update_login OUT NOCOPY NUMBER,
138 x_last_update_date OUT NOCOPY DATE,
139
140 x_primary_contract_doc_flag OUT NOCOPY VARCHAR2,
141 x_mergeable_doc_flag OUT NOCOPY VARCHAR2
142
143 ) RETURN VARCHAR2;
144
145
146
147 --API name : reset_bus_doc_ver_to_current
148 --Type : Private.
149 --Function : When: This API is invoked from the Repository module. It is called when
150 -- a contract's current version is deleted and a previous version of that contract
151 -- exists.
152 -- : What: This API updates the previous version's attachments in OKC_CONTRACT_DOCS.
153 -- : This function does two things:
154 -- : 1. Updates the BUSINESS_DOCUMENT_VERSION from its current value to -99.
155 -- : 2. Updates the EFFECTIVE_FROM_VERSION to -99 for those attachments that were effective
156 -- : from this current version only (not added from a previous version).
157 -- : Why: This reset is required since Contract Documents (module) requires attachments of the current
158 -- : version of a business document (contract) to have a BUSINESS_DOCUMENT_VERSION of -99.
159 --Pre-reqs : None.
160 --Parameters :
161 --IN : p_business_document_type IN VARCHAR2 Required
162 -- : p_business_document_id IN NUMBER Required
163 -- : p_business_document_version IN NUMBER Required
164 --OUT : Returns G_RET_STS_SUCCESS if resetting of version number is succeeded.
165 --Note : This API is created as part of the fix of bug 5044121
166 -- End of comments
167 FUNCTION reset_bus_doc_ver_to_current(
168 p_business_document_type IN VARCHAR2,
169 p_business_document_id IN NUMBER,
170 p_business_document_version IN NUMBER
171 ) RETURN VARCHAR2;
172
173
174
175 END OKC_CONTRACT_DOCS_PVT;