[Home] [Help]
PACKAGE: APPS.OKC_TERMS_COPY_PVT
Source
1 PACKAGE OKC_TERMS_COPY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVDCPS.pls 120.4.12020000.2 2013/01/18 12:12:57 serukull ship $ */
3
4 procedure copy_tc(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
7 p_commit IN VARCHAR2 default fnd_api.g_false,
8 p_source_doc_type IN VARCHAR2,
9 p_source_doc_id IN NUMBER,
10 p_target_doc_type IN OUT NOCOPY VARCHAR2,
11 p_target_doc_id IN OUT NOCOPY NUMBER,
12 p_keep_version IN VARCHAR2 default 'N',
13 p_article_effective_date IN DATE,
14 p_target_template_rec IN OKC_TERMS_TEMPLATES_PVT.template_rec_type,
15 p_document_number IN VARCHAR2 default Null,
16 p_retain_deliverable IN VARCHAR2 default 'N',
17 p_allow_duplicates IN VARCHAR2 default 'N',
18 p_keep_orig_ref IN VARCHAR2 default 'N',
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 p_copy_abstract_yn IN VARCHAR default 'N',
23 p_copy_for_amendment IN VARCHAR2 default 'N',
24 p_contract_admin_id IN NUMBER := NULL,
25 p_legal_contact_id IN NUMBER := NULL,
26 p_retain_clauses IN VARCHAR2 default 'N' --kkolukul: CLM Changes
27 , p_retain_lock_terms_yn IN VARCHAR2 := 'N' -- conc Mod changes start
28 ,p_retain_lock_xprt_yn IN VARCHAR2 := 'N' -- conc Mod changes start
29 );
30
31
32 procedure copy_archived_doc(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
35 p_commit IN VARCHAR2 default fnd_api.g_false,
36 p_source_doc_type IN VARCHAR2,
37 p_source_doc_id IN NUMBER,
38 p_source_version_number IN NUMBER,
39 p_target_doc_type IN VARCHAR2,
40 p_target_doc_id IN NUMBER,
41 p_document_number IN VARCHAR2 default Null,
42 p_allow_duplicates IN VARCHAR2 default 'N',
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER
46 );
47
48 FUNCTION get_variable_value_id (
49 p_cat_id IN NUMBER,
50 p_variable_code IN VARCHAR2)
51 RETURN VARCHAR2;
52
53 FUNCTION get_variable_value (
54 p_cat_id IN NUMBER,
55 p_variable_code IN VARCHAR2)
56 RETURN VARCHAR2;
57
58 FUNCTION get_orig_var_val (
59 p_cat_id IN NUMBER,
60 p_variable_code IN VARCHAR2,
61 p_source_doc_id IN NUMBER,
62 p_source_doc_type IN VARCHAR2,
63 p_value_type IN VARCHAR2)
64 RETURN VARCHAR2;
65
66 FUNCTION get_orig_var_val_xml (
67 p_cat_id IN NUMBER,
68 p_variable_code IN VARCHAR2,
69 p_source_doc_id IN NUMBER,
70 p_source_doc_type IN VARCHAR2,
71 p_value_type IN VARCHAR2)
72 RETURN CLOB;
73
74 END OKC_TERMS_COPY_PVT;