DBA Data[Home] [Help]

PACKAGE: APPS.OKC_TEMPLATE_USAGES_PVT

Source


1 PACKAGE OKC_TEMPLATE_USAGES_PVT AS
2 /* $Header: OKCVTMPLUSGS.pls 120.1.12000000.1 2007/01/17 11:34:06 appldev ship $ */
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_document_type          IN VARCHAR2,
13     p_document_id            IN NUMBER,
14     p_template_id            IN NUMBER,
15     p_doc_numbering_scheme   IN NUMBER,
16     p_document_number        IN VARCHAR2,
17     p_article_effective_date IN DATE,
18     p_config_header_id       IN NUMBER,
19     p_config_revision_number IN NUMBER,
20     p_valid_config_yn        IN VARCHAR2,
21     p_orig_system_reference_code IN VARCHAR2 := NULL,
22     p_orig_system_reference_id1 IN NUMBER := NULL,
23     p_orig_system_reference_id2 IN NUMBER := NULL,
24 
25 --added for 10+ word integration and deviations report
26     p_authoring_party_code   IN VARCHAR2 :=  NULL,  --default based on doc_type
27     p_contract_source_code   IN VARCHAR2 := 'STRUCTURED',
28     p_approval_abstract_text IN CLOB := NULL,
29     p_autogen_deviations_flag IN VARCHAR2 := NULL,
30 --added for bug# 3990983
31     p_source_change_allowed_flag IN VARCHAR2 := 'Y',
32     x_document_type          OUT NOCOPY VARCHAR2,
33     x_document_id            OUT NOCOPY NUMBER,
34     p_lock_terms_flag        IN VARCHAR2 := NULL,
35     p_enable_reporting_flag  IN VARCHAR2 := NULL,
36     p_contract_admin_id      IN NUMBER := NULL,
37     p_legal_contact_id       IN NUMBER := NULL,
38     p_locked_by_user_id      IN NUMBER := NULL
39   );
40 
41   PROCEDURE lock_row(
42     x_return_status                OUT NOCOPY VARCHAR2,
43 
44     p_document_type          IN VARCHAR2,
45     p_document_id            IN NUMBER,
46 
47     p_object_version_number  IN NUMBER
48   );
49 
50   PROCEDURE update_row(
51     p_validation_level             IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52     x_return_status                OUT NOCOPY VARCHAR2,
53 
54     p_document_type          IN VARCHAR2,
55     p_document_id            IN NUMBER,
56     p_template_id            IN NUMBER := NULL,
57     p_doc_numbering_scheme   IN NUMBER := NULL,
58     p_document_number        IN VARCHAR2 := NULL,
59     p_article_effective_date IN DATE := NULL,
60     p_config_header_id       IN NUMBER := NULL,
61     p_config_revision_number IN NUMBER := NULL,
62     p_valid_config_yn        IN VARCHAR2 := NULL,
63     p_orig_system_reference_code IN VARCHAR2 := NULL,
64     p_orig_system_reference_id1 IN NUMBER := NULL,
65     p_orig_system_reference_id2 IN NUMBER := NULL,
66 
67     p_object_version_number  IN NUMBER := NULL,
68 
69 --added for 10+ word integration and deviations report
70     p_authoring_party_code   IN VARCHAR2 := NULL,  -- default- not updated.
71     p_contract_source_code   IN VARCHAR2 := NULL,
72     p_approval_abstract_text IN CLOB := NULL,
73     p_autogen_deviations_flag IN VARCHAR2 := NULL,
74 --added for bug# 3990983
75     p_source_change_allowed_flag IN VARCHAR2 := NULL ,
76     p_lock_terms_flag        IN VARCHAR2 := NULL,
77     p_enable_reporting_flag  IN VARCHAR2 := NULL,
78     p_contract_admin_id      IN NUMBER := NULL,
79     p_legal_contact_id       IN NUMBER := NULL,
80     p_locked_by_user_id      IN NUMBER := NULL
81   );
82 
83   PROCEDURE delete_row(
84     x_return_status                OUT NOCOPY VARCHAR2,
85 
86     p_document_type          IN VARCHAR2,
87     p_document_id            IN NUMBER,
88 
89     p_object_version_number  IN NUMBER
90   );
91 
92   PROCEDURE validate_row(
93     p_validation_level             IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94     x_return_status                OUT NOCOPY VARCHAR2,
95 
96     p_document_type          IN VARCHAR2,
97     p_document_id            IN NUMBER,
98     p_template_id            IN NUMBER,
99     p_doc_numbering_scheme   IN NUMBER,
100     p_document_number        IN VARCHAR2,
101     p_article_effective_date IN DATE,
102     p_config_header_id       IN NUMBER,
103     p_config_revision_number IN NUMBER,
104     p_valid_config_yn        IN VARCHAR2,
105     p_orig_system_reference_code IN VARCHAR2 := NULL,
106     p_orig_system_reference_id1 IN NUMBER := NULL,
107     p_orig_system_reference_id2 IN NUMBER := NULL,
108 
109     p_object_version_number  IN NUMBER,
110 
111 --added for 10+ word integration and deviations report
112     p_authoring_party_code   IN VARCHAR2 :=  NULL,  --default based on doc_type
113     p_contract_source_code   IN VARCHAR2 := 'STRUCTURED',
114     p_approval_abstract_text IN CLOB := NULL,
115     p_autogen_deviations_flag IN VARCHAR2 := NULL,
116 --added for bug# 3990983
117     p_source_change_allowed_flag IN VARCHAR2 := 'Y',
118     p_lock_terms_flag        IN VARCHAR2 := NULL,
119     p_enable_reporting_flag  IN VARCHAR2 := NULL,
120     p_contract_admin_id      IN NUMBER := NULL,
121     p_legal_contact_id       IN NUMBER := NULL,
122     p_locked_by_user_id      IN NUMBER := NULL
123   );
124 
125   FUNCTION get_rec (
126     p_document_type          IN VARCHAR2,
127     p_document_id            IN NUMBER,
128 
129     x_template_id            OUT NOCOPY NUMBER,
130     x_doc_numbering_scheme   OUT NOCOPY NUMBER,
131     x_document_number        OUT NOCOPY VARCHAR2,
132     x_article_effective_date OUT NOCOPY DATE,
133     x_config_header_id       OUT NOCOPY NUMBER,
134     x_config_revision_number OUT NOCOPY NUMBER,
135     x_valid_config_yn        OUT NOCOPY VARCHAR2,
136     x_orig_system_reference_code OUT NOCOPY VARCHAR2,
137     x_orig_system_reference_id1 OUT NOCOPY NUMBER,
138     x_orig_system_reference_id2 OUT NOCOPY NUMBER,
139     x_object_version_number  OUT NOCOPY NUMBER,
140     x_created_by             OUT NOCOPY NUMBER,
141     x_creation_date          OUT NOCOPY DATE,
142     x_last_updated_by        OUT NOCOPY NUMBER,
143     x_last_update_login      OUT NOCOPY NUMBER,
144     x_last_update_date       OUT NOCOPY DATE,
145 
146 --added for 10+ word integration and deviations report
147     x_authoring_party_code   OUT NOCOPY VARCHAR2 ,
148     x_contract_source_code   OUT NOCOPY VARCHAR2 ,
149     x_approval_abstract_text OUT NOCOPY CLOB ,
150     x_autogen_deviations_flag OUT NOCOPY VARCHAR2 ,
151 --added for bug# 3990983
152     x_source_change_allowed_flag OUT NOCOPY VARCHAR2 ,
153     x_lock_terms_flag        OUT NOCOPY VARCHAR2,
154     x_enable_reporting_flag  OUT NOCOPY VARCHAR2,
155     x_contract_admin_id      OUT NOCOPY NUMBER,
156     x_legal_contact_id       OUT NOCOPY NUMBER,
157     x_locked_by_user_id      OUT NOCOPY NUMBER
158   ) RETURN VARCHAR2;
159 
160 
161   FUNCTION Create_Version(
162     p_doc_type                     IN VARCHAR2,
163     p_doc_id                       IN NUMBER,
164     p_major_version                IN NUMBER
165   ) RETURN VARCHAR2;
166 
167   FUNCTION Restore_Version(
168     p_doc_type                     IN VARCHAR2,
169     p_doc_id                       IN NUMBER,
170     p_major_version                NUMBER
171   ) RETURN VARCHAR2;
172 
173 --This Function is called from Versioning API OKC_VERSION_PVT
174 -- to delete template usages for specified version of document
175 
176   FUNCTION Delete_Version(
177     p_doc_type                     IN VARCHAR2,
178     p_doc_id                       IN NUMBER,
179     p_major_version                IN NUMBER
180   ) RETURN VARCHAR2;
181 
182   PROCEDURE Update_Template_Id(
183             x_return_status         OUT NOCOPY VARCHAR2,
184             p_old_template_id       IN NUMBER,
185             p_new_template_id       IN NUMBER
186     );
187     PROCEDURE Delete_Set(
188             x_return_status         OUT NOCOPY VARCHAR2,
189             p_template_id           IN NUMBER
190     );
191 END OKC_TEMPLATE_USAGES_PVT;