[Home] [Help]
PACKAGE: APPS.OKC_CLM_PKG
Source
1 PACKAGE okc_clm_pkg AUTHID CURRENT_USER AS
2 /* $Header: OKCCLMPS.pls 120.3 2011/01/17 15:39:04 kkolukul noship $ */
3
4 TYPE var_value_rec_type IS RECORD (
5 variable_code VARCHAR2(30),
6 variable_value_id VARCHAR2(2500)
7 );
8
9 TYPE udf_var_value_tbl_type IS TABLE OF var_value_rec_type INDEX BY BINARY_INTEGER;
10
11 PROCEDURE get_user_defined_variables (
12 p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14 p_doc_type IN VARCHAR2,
15 p_doc_id IN NUMBER,
16 p_org_id IN NUMBER,
17 p_intent IN VARCHAR2,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_data OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
22 );
23
24 PROCEDURE get_udv_with_procedures (
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27 p_doc_type IN VARCHAR2,
28 p_doc_id IN NUMBER,
29 p_org_id IN NUMBER,
30 p_intent IN VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
35 );
36
37 PROCEDURE get_clm_udv (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_doc_type IN VARCHAR2,
41 p_doc_id IN NUMBER,
42 p_org_id IN NUMBER,
43 p_intent IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
48 );
49
50 PROCEDURE set_clm_udv(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 p_document_type IN VARCHAR2,
54 p_document_id IN NUMBER,
55 p_output_error IN VARCHAR2 := FND_API.G_TRUE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER
59 );
60
61 PROCEDURE get_default_scn_code (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_article_id IN NUMBER,
65 p_article_version_id IN NUMBER,
66 p_doc_id IN NUMBER,
67 p_doc_type IN VARCHAR2,
68 x_default_scn_code OUT NOCOPY OKC_SECTIONS_B.SCN_CODE%TYPE,
69 x_return_status OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE get_system_variables (
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 p_doc_type IN VARCHAR2,
79 p_doc_id IN NUMBER,
80 p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
81 x_sys_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.var_value_tbl_type
82 );
83
84 PROCEDURE clm_remove_dup_scn_art( p_document_type IN VARCHAR2,
85 p_document_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER);
89
90 PROCEDURE clm_remove_dup_articles( p_document_type IN VARCHAR2,
91 p_document_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER);
95
96 PROCEDURE clm_remove_dup_sections( p_document_type IN VARCHAR2,
97 p_document_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER);
101
102 PROCEDURE insert_usages_row( p_document_type IN VARCHAR2,
103 p_document_id IN NUMBER,
104 p_template_id IN NUMBER,
105 p_doc_numbering_scheme IN NUMBER,
106 p_document_number IN VARCHAR2,
107 p_article_effective_date IN DATE,
108 p_config_header_id IN NUMBER,
109 p_config_revision_number IN NUMBER,
110 p_valid_config_yn IN VARCHAR2,
111 p_orig_system_reference_code IN VARCHAR2 := NULL,
112 p_orig_system_reference_id1 IN NUMBER := NULL,
113 p_orig_system_reference_id2 IN NUMBER := NULL,
114 p_lock_terms_flag IN VARCHAR2 := NULL,
115 p_locked_by_user_id IN NUMBER := NULL,
116 p_primary_template IN VARCHAR2 := 'N',
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER);
120
121 PROCEDURE Delete_Usages_Row(
122 x_return_status OUT NOCOPY VARCHAR2,
123 p_document_type IN VARCHAR2,
124 p_document_id IN NUMBER,
125 p_object_version_number IN NUMBER);
126
127 FUNCTION check_dup_templates( p_document_type IN VARCHAR2,
128 p_document_id IN NUMBER,
129 p_template_id IN NUMBER)
130 RETURN VARCHAR2;
131
132 PROCEDURE copy_usages_row(
133 p_target_doc_type IN VARCHAR2,
134 p_source_doc_type IN VARCHAR2,
135 p_target_doc_id IN NUMBER,
136 p_source_doc_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER);
140
141
142 END OKC_CLM_PKG;