[Home] [Help]
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PUB
Source
1 PACKAGE HZ_ORIG_SYSTEM_REF_PUB AS
2 /*$Header: ARHPOSRS.pls 120.10 2006/08/17 10:18:02 idali noship $ */
3 /*#
4 * This package contains the public APIs related to source systems.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Source System Management
8 * @rep:category BUSINESS_ENTITY HZ_EXTERNAL_REFERENCE
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 --------------------------------------
14 -- declaration of record type
15 --------------------------------------
16 TYPE orig_sys_entity_map_rec_type IS RECORD (
17 orig_system VARCHAR2(30),
18 owner_table_name VARCHAR2(30),
19 status VARCHAR2(1),
20 multiple_flag VARCHAR2(1),
21 --raji
22 multi_osr_flag VARCHAR2(1),
23 created_by_module VARCHAR2(150),
24 application_id NUMBER,
25 attribute_category VARCHAR2(30),
26 attribute1 VARCHAR2(150),
27 attribute2 VARCHAR2(150),
28 attribute3 VARCHAR2(150),
29 attribute4 VARCHAR2(150),
30 attribute5 VARCHAR2(150),
31 attribute6 VARCHAR2(150),
32 attribute7 VARCHAR2(150),
33 attribute8 VARCHAR2(150),
34 attribute9 VARCHAR2(150),
35 attribute10 VARCHAR2(150),
36 attribute11 VARCHAR2(150),
37 attribute12 VARCHAR2(150),
38 attribute13 VARCHAR2(150),
39 attribute14 VARCHAR2(150),
40 attribute15 VARCHAR2(150),
41 attribute16 VARCHAR2(150),
42 attribute17 VARCHAR2(150),
43 attribute18 VARCHAR2(150),
44 attribute19 VARCHAR2(150),
45 attribute20 VARCHAR2(150)
46 );
47
48 TYPE orig_sys_reference_rec_type IS RECORD (
49 orig_system_ref_id NUMBER,
50 orig_system VARCHAR2(30),
51 orig_system_reference VARCHAR2(255),
52 owner_table_name VARCHAR2(30),
53 owner_table_id NUMBER,
54 --raji
55 party_id NUMBER,
56 status VARCHAR2(1),
57 reason_code VARCHAR2(30),
58 old_orig_system_reference VARCHAR2(255),
59 start_date_active DATE,
60 end_date_active DATE,
61 created_by_module VARCHAR2(150),
62 application_id NUMBER,
63 attribute_category VARCHAR2(30),
64 attribute1 VARCHAR2(150),
65 attribute2 VARCHAR2(150),
66 attribute3 VARCHAR2(150),
67 attribute4 VARCHAR2(150),
68 attribute5 VARCHAR2(150),
69 attribute6 VARCHAR2(150),
70 attribute7 VARCHAR2(150),
71 attribute8 VARCHAR2(150),
72 attribute9 VARCHAR2(150),
73 attribute10 VARCHAR2(150),
74 attribute11 VARCHAR2(150),
75 attribute12 VARCHAR2(150),
76 attribute13 VARCHAR2(150),
77 attribute14 VARCHAR2(150),
78 attribute15 VARCHAR2(150),
79 attribute16 VARCHAR2(150),
80 attribute17 VARCHAR2(150),
81 attribute18 VARCHAR2(150),
82 attribute19 VARCHAR2(150),
83 attribute20 VARCHAR2(150)
84 );
85
86 --------------------------------------
87 -- declaration of procedures and functions
88 --------------------------------------
89
90 PROCEDURE get_orig_sys_entity_map_rec (
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_orig_system in varchar2,
93 p_owner_table_name in varchar2,
94 x_orig_sys_entity_map_rec OUT NOCOPY ORIG_SYS_ENTITY_MAP_REC_TYPE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE get_orig_sys_reference_rec (
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_orig_system_ref_id in number,
103 x_orig_sys_reference_rec OUT NOCOPY ORIG_SYS_REFERENCE_REC_TYPE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 /*#
110 * Use this routine to create a mapping between a source system reference and a TCA
111 * owner_table_id.
112 * @rep:scope public
113 * @rep:lifecycle active
114 * @rep:displayname Create Original System Reference
115 * @rep:businessevent oracle.apps.ar.hz.origSystemRef.create
116 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
117 */
118 PROCEDURE create_orig_system_reference(
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_orig_sys_reference_rec IN ORIG_SYS_REFERENCE_REC_TYPE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126
127 /*#
128 * Use this routine to re-map or update source system references.
129 * @rep:scope public
130 * @rep:lifecycle active
131 * @rep:displayname Update Original System Reference
132 * @rep:businessevent oracle.apps.ar.hz.origSystemRef.update
133 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
134 */
135 PROCEDURE update_orig_system_reference(
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_orig_sys_reference_rec IN ORIG_SYS_REFERENCE_REC_TYPE,
138 p_object_version_number IN OUT NOCOPY NUMBER,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144
145 /*#
146 * Use this routine to re-map the owner_table_id from an existing owner table id to a
147 * new owner table id for any system and to inactivate existing mapping with a reason code.
148 * @rep:scope public
149 * @rep:lifecycle active
150 * @rep:displayname Remap Internal Identifier
151 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
152 */
153 PROCEDURE remap_internal_identifier(
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_old_owner_table_id IN NUMBER,
156 p_new_owner_table_id IN NUMBER,
157 p_owner_table_name IN VARCHAR2,
158 p_orig_system IN VARCHAR2,
159 p_orig_system_reference IN VARCHAR2,
160 p_reason_code IN VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 procedure get_owner_table_id(p_orig_system in varchar2,
167 p_orig_system_reference in varchar2,
168 p_owner_table_name in varchar2,
169 x_owner_table_id out nocopy number,
170 x_return_status out nocopy varchar2);
171
172
173 END HZ_ORIG_SYSTEM_REF_PUB;