1 PACKAGE OKC_XPRT_XRULE_VALUES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVXXRULVS.pls 120.4 2007/02/20 04:03:31 arsundar ship $ */
3
4
5 TYPE var_value_rec_type IS RECORD (
6 variable_code VARCHAR2(30),
7 variable_value_id VARCHAR2(2500)
8 );
9
10 TYPE category_rec_type IS RECORD (
11 category_name VARCHAR2(2000)
12 );
13
14 TYPE item_rec_type IS RECORD (
15 name VARCHAR2(2000)
16 );
17
18 TYPE constant_rec_type IS RECORD (
19 constant_id VARCHAR2(30),
20 value VARCHAR2(50)
21 );
22
23 TYPE sys_var_value_tbl_type IS TABLE OF var_value_rec_type INDEX BY BINARY_INTEGER;
24 TYPE category_tbl_type IS TABLE OF category_rec_type INDEX BY BINARY_INTEGER;
25 TYPE item_tbl_type IS TABLE OF item_rec_type INDEX BY BINARY_INTEGER;
26 TYPE constant_tbl_type IS TABLE OF constant_rec_type INDEX BY BINARY_INTEGER;
27
28 --Added for 12
29 TYPE line_sys_var_value_rec_type IS RECORD (
30 line_NUMBER VARCHAR2(250),
31 variable_code VARCHAR2(30),
32 variable_value VARCHAR2(2500),
33 item_id NUMBER,
34 org_id NUMBER
35 );
36
37 TYPE line_sys_var_value_tbl_type IS TABLE OF line_sys_var_value_rec_type INDEX BY BINARY_INTEGER;
38
39 TYPE udf_var_value_tbl_type IS TABLE OF var_value_rec_type INDEX BY BINARY_INTEGER;
40
41 TYPE var_value_tbl_type IS TABLE OF var_value_rec_type INDEX BY BINARY_INTEGER;
42
43 ---------------------------------------------------
44 -- Procedure:
45 ---------------------------------------------------
46
47 PROCEDURE get_system_variables (
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 p_doc_type IN VARCHAR2,
54 p_doc_id IN NUMBER,
55 p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
56 x_sys_var_value_tbl OUT NOCOPY var_value_tbl_type
57 );
58
59 PROCEDURE get_constant_values (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_intent IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_constant_tbl OUT NOCOPY constant_tbl_type
67 );
68
69 --Added for 12
70 PROCEDURE get_line_system_variables (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_doc_type IN VARCHAR2,
74 p_doc_id IN NUMBER,
75 p_org_id IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_line_sys_var_value_tbl OUT NOCOPY line_sys_var_value_tbl_type,
80 x_line_count OUT NOCOPY NUMBER,
81 x_line_variables_count OUT NOCOPY NUMBER
82 );
83
84 PROCEDURE get_user_defined_variables (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87 p_doc_type IN VARCHAR2,
88 p_doc_id IN NUMBER,
89 p_org_id IN NUMBER,
90 p_intent IN VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_udf_var_value_tbl OUT NOCOPY udf_var_value_tbl_type
95 );
96
97 PROCEDURE get_document_values (
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100 p_doc_type IN VARCHAR2,
101 p_doc_id IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_hdr_var_value_tbl OUT NOCOPY var_value_tbl_type,
106 x_line_sysvar_value_tbl OUT NOCOPY line_sys_var_value_tbl_type,
107 x_line_count OUT NOCOPY NUMBER,
108 x_line_variables_count OUT NOCOPY NUMBER,
109 x_intent OUT NOCOPY VARCHAR2,
110 x_org_id OUT NOCOPY NUMBER
111 );
112
113 FUNCTION check_line_level_rule_exists (
114 p_doc_type IN VARCHAR2,
115 p_doc_id IN NUMBER,
116 p_org_id IN NUMBER
117 ) RETURN VARCHAR2;
118
119 -- Added for 12.0+
120
121 PROCEDURE get_udv_with_procedures (
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 p_doc_type IN VARCHAR2,
125 p_doc_id IN NUMBER,
126 p_org_id IN NUMBER,
127 p_intent IN VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_udf_var_value_tbl OUT NOCOPY udf_var_value_tbl_type
132 );
133
134 END OKC_XPRT_XRULE_VALUES_PVT;