[Home] [Help]
PACKAGE: APPS.OKC_TERMS_COPY_PVT
Source
1 PACKAGE OKC_TERMS_COPY_PVT AS
2 /* $Header: OKCVDCPS.pls 120.1.12000000.1 2007/01/17 11:32:24 appldev 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 );
27
28
29 procedure copy_archived_doc(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
32 p_commit IN VARCHAR2 default fnd_api.g_false,
33 p_source_doc_type IN VARCHAR2,
34 p_source_doc_id IN NUMBER,
35 p_source_version_number IN NUMBER,
36 p_target_doc_type IN VARCHAR2,
37 p_target_doc_id IN NUMBER,
38 p_document_number IN VARCHAR2 default Null,
39 p_allow_duplicates IN VARCHAR2 default 'N',
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER
43 );
44
45 FUNCTION get_variable_value_id (
46 p_cat_id IN NUMBER,
47 p_variable_code IN VARCHAR2)
48 RETURN VARCHAR2;
49
50 FUNCTION get_variable_value (
51 p_cat_id IN NUMBER,
52 p_variable_code IN VARCHAR2)
53 RETURN VARCHAR2;
54
55 FUNCTION get_orig_var_val (
56 p_cat_id IN NUMBER,
57 p_variable_code IN VARCHAR2,
58 p_source_doc_id IN NUMBER,
59 p_source_doc_type IN VARCHAR2,
60 p_value_type IN VARCHAR2)
61 RETURN VARCHAR2;
62
63 END OKC_TERMS_COPY_PVT;