[Home] [Help]
PACKAGE: APPS.ECX_XREF_API
Source
1 package ecx_xref_api as
2 /* $Header: ECXXRFAS.pls 120.2 2005/06/30 11:19:09 appldev ship $ */
3
4 PROCEDURE create_code_category(
5 x_return_status OUT NOCOPY PLS_INTEGER,
6 x_msg OUT NOCOPY VARCHAR2,
7 x_xref_hdr_id OUT NOCOPY PLS_INTEGER,
8 p_xref_category_code IN VARCHAR2,
9 p_description IN VARCHAR2,
10 p_owner IN VARCHAR2 DEFAULT 'CUSTOM');
11
12 PROCEDURE delete_code_category(
13 x_return_status OUT NOCOPY PLS_INTEGER,
14 x_msg OUT NOCOPY VARCHAR2,
15 p_xref_category_id IN PLS_INTEGER);
16
17 PROCEDURE update_code_category(
18 x_return_status OUT NOCOPY PLS_INTEGER,
19 x_msg OUT NOCOPY VARCHAR2,
20 p_xref_category_id IN PLS_INTEGER,
21 p_xref_category_code IN VARCHAR2,
22 p_description IN VARCHAR2,
23 p_owner IN VARCHAR2 DEFAULT 'CUSTOM');
24
25
26 PROCEDURE retrieve_tp_external_value(
27 x_return_status OUT NOCOPY PLS_INTEGER,
28 x_msg OUT NOCOPY VARCHAR2,
29 x_xref_ext_value OUT NOCOPY VARCHAR2,
30 p_tp_header_id IN PLS_INTEGER,
31 p_xref_category_code IN VARCHAR2,
32 p_standard IN VARCHAR2,
33 p_xref_int_value IN VARCHAR2,
34 x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
35 p_standard_type IN VARCHAR2 DEFAULT 'XML');
36
37 PROCEDURE retrieve_tp_internal_value(
38 x_return_status OUT NOCOPY PLS_INTEGER,
39 x_msg OUT NOCOPY VARCHAR2,
40 x_xref_int_value OUT NOCOPY VARCHAR2,
41 p_tp_header_id IN PLS_INTEGER,
42 p_xref_category_code IN VARCHAR2,
43 p_standard IN VARCHAR2,
44 p_xref_ext_value IN VARCHAR2,
45 x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
46 p_standard_type IN VARCHAR2 DEFAULT 'XML');
47
48 PROCEDURE retrieve_tp_code_values_by_id(
49 x_return_status OUT NOCOPY PLS_INTEGER,
50 x_msg OUT NOCOPY VARCHAR2,
51 x_xref_category_code OUT NOCOPY VARCHAR2,
52 x_standard_code OUT NOCOPY VARCHAR2,
53 x_xref_ext_value OUT NOCOPY VARCHAR2,
54 x_xref_int_value OUT NOCOPY VARCHAR2,
55 x_direction OUT NOCOPY VARCHAR2,
56 p_xref_dtl_id IN PLS_INTEGER,
57 x_cat_description OUT NOCOPY VARCHAR2,
58 x_xref_category_id OUT NOCOPY NUMBER,
59 x_standard_id OUT NOCOPY PLS_INTEGER,
60 x_tp_header_id OUT NOCOPY PLS_INTEGER,
61 x_description OUT NOCOPY VARCHAR2,
62 x_created_by OUT NOCOPY PLS_INTEGER,
63 x_creation_date OUT NOCOPY DATE,
64 x_last_updated_by OUT NOCOPY PLS_INTEGER,
65 x_last_update_date OUT NOCOPY DATE);
66
67 PROCEDURE retrieve_tp_code_values(
68 x_return_status OUT NOCOPY PLS_INTEGER,
69 x_msg OUT NOCOPY VARCHAR2,
70 x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
71 x_xref_category_id OUT NOCOPY PLS_INTEGER,
72 p_xref_category_code IN VARCHAR2,
73 p_standard IN VARCHAR2,
74 p_xref_ext_value IN VARCHAR2,
75 p_xref_int_value IN VARCHAR2,
76 p_direction IN VARCHAR2,
77 x_cat_description OUT NOCOPY VARCHAR2,
78 x_standard_id OUT NOCOPY PLS_INTEGER,
79 x_tp_header_id OUT NOCOPY PLS_INTEGER,
80 x_description OUT NOCOPY VARCHAR2,
81 x_created_by OUT NOCOPY PLS_INTEGER,
82 x_creation_date OUT NOCOPY DATE,
83 x_last_updated_by OUT NOCOPY PLS_INTEGER,
84 x_last_update_date OUT NOCOPY DATE,
85 p_standard_type IN VARCHAR2 DEFAULT 'XML');
86
87 PROCEDURE create_tp_code_values(
88 x_return_status OUT NOCOPY PLS_INTEGER,
89 x_msg OUT NOCOPY VARCHAR2,
90 x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
91 x_xref_category_id OUT NOCOPY PLS_INTEGER,
92 p_xref_category_code IN VARCHAR2,
93 p_standard IN VARCHAR2,
94 p_tp_header_id IN PLS_INTEGER,
95 p_xref_ext_value IN VARCHAR2,
96 p_xref_int_value IN VARCHAR2,
97 p_description IN VARCHAR2,
98 p_direction IN VARCHAR2,
99 p_standard_type IN VARCHAR2 DEFAULT 'XML');
100
101 PROCEDURE update_tp_code_values(
102 x_return_status OUT NOCOPY PLS_INTEGER,
103 x_msg OUT NOCOPY VARCHAR2,
104 p_xref_dtl_id IN PLS_INTEGER,
105 p_xref_ext_value IN VARCHAR2,
106 p_xref_int_value IN VARCHAR2,
107 p_tp_header_id IN PLS_INTEGER,
108 p_description IN VARCHAR2,
109 p_direction IN VARCHAR2);
110
111 PROCEDURE delete_tp_code_values(
112 x_return_status OUT NOCOPY PLS_INTEGER,
113 x_msg OUT NOCOPY VARCHAR2,
114 p_xref_dtl_id IN PLS_INTEGER);
115
116 PROCEDURE retrieve_standard_code_values(
117 x_return_status OUT NOCOPY PLS_INTEGER,
118 x_msg OUT NOCOPY VARCHAR2,
119 x_xref_std_id OUT NOCOPY PLS_INTEGER,
120 x_xref_category_id OUT NOCOPY PLS_INTEGER,
121 p_xref_category_code IN VARCHAR2,
122 p_standard IN VARCHAR2,
123 p_xref_std_value IN VARCHAR2,
124 p_xref_int_value IN VARCHAR2,
125 x_cat_description OUT NOCOPY VARCHAR2,
126 x_standard_id OUT NOCOPY PLS_INTEGER,
127 x_description OUT NOCOPY VARCHAR2,
128 x_data_seeded OUT NOCOPY VARCHAR2,
129 x_created_by OUT NOCOPY PLS_INTEGER,
130 x_creation_date OUT NOCOPY DATE,
131 x_last_updated_by OUT NOCOPY PLS_INTEGER,
132 x_last_update_date OUT NOCOPY DATE,
133 p_standard_type IN VARCHAR2 DEFAULT 'XML');
134
135
136 PROCEDURE create_standard_code_values(
137 x_return_status OUT NOCOPY PLS_INTEGER,
138 x_msg OUT NOCOPY VARCHAR2,
139 x_xref_std_id OUT NOCOPY PLS_INTEGER,
140 x_xref_category_id OUT NOCOPY PLS_INTEGER,
141 p_xref_category_code IN VARCHAR2,
142 p_standard IN VARCHAR2,
143 p_xref_std_value IN VARCHAR2,
144 p_xref_int_value IN VARCHAR2,
145 p_description IN VARCHAR2,
146 p_data_seeded IN VARCHAR2 DEFAULT 'N',
147 p_owner IN VARCHAR2 DEFAULT 'CUSTOM',
148 p_standard_type IN VARCHAR2 DEFAULT 'XML'
149 );
150
151 PROCEDURE update_standard_code_values(
152 x_return_status OUT NOCOPY PLS_INTEGER,
153 x_msg OUT NOCOPY VARCHAR2,
154 p_xref_standard_id IN PLS_INTEGER,
155 p_xref_std_value IN VARCHAR2,
156 p_xref_int_value IN VARCHAR2,
157 p_description IN VARCHAR2,
158 p_owner IN VARCHAR2 DEFAULT 'CUSTOM'
159 );
160
161 PROCEDURE delete_standard_code_values(
162 x_return_status OUT NOCOPY PLS_INTEGER,
163 x_msg OUT NOCOPY VARCHAR2,
164 p_xref_standard_id IN PLS_INTEGER
165 );
166
167 end ECX_XREF_API;