[Home] [Help]
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PUB
Source
1 PACKAGE HZ_ORIG_SYSTEM_REF_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHPOSRS.pls 120.11 2011/12/10 09:57:18 rgokavar ship $ */
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 dqm_sync_mode VARCHAR2(1)
85 );
86
87 --------------------------------------
88 -- declaration of procedures and functions
89 --------------------------------------
90
91 PROCEDURE get_orig_sys_entity_map_rec (
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_orig_system in varchar2,
94 p_owner_table_name in varchar2,
95 x_orig_sys_entity_map_rec OUT NOCOPY ORIG_SYS_ENTITY_MAP_REC_TYPE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 PROCEDURE get_orig_sys_reference_rec (
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_orig_system_ref_id in number,
104 x_orig_sys_reference_rec OUT NOCOPY ORIG_SYS_REFERENCE_REC_TYPE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110 /*#
111 * Use this routine to create a mapping between a source system reference and a TCA
112 * owner_table_id.
113 * @rep:scope public
114 * @rep:lifecycle active
115 * @rep:displayname Create Original System Reference
116 * @rep:businessevent oracle.apps.ar.hz.origSystemRef.create
117 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
118 */
119 PROCEDURE create_orig_system_reference(
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121 p_orig_sys_reference_rec IN ORIG_SYS_REFERENCE_REC_TYPE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2
125 );
126
127
128 /*#
129 * Use this routine to re-map or update source system references.
130 * @rep:scope public
131 * @rep:lifecycle active
132 * @rep:displayname Update Original System Reference
133 * @rep:businessevent oracle.apps.ar.hz.origSystemRef.update
134 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
135 */
136 PROCEDURE update_orig_system_reference(
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_orig_sys_reference_rec IN ORIG_SYS_REFERENCE_REC_TYPE,
139 p_object_version_number IN OUT NOCOPY NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145
146 /*#
147 * Use this routine to re-map the owner_table_id from an existing owner table id to a
148 * new owner table id for any system and to inactivate existing mapping with a reason code.
149 * @rep:scope public
150 * @rep:lifecycle active
151 * @rep:displayname Remap Internal Identifier
152 * @rep:doccd 120hztig.pdf Source System Management APIs, Oracle Trading Community Architecture Technical Implementation Guide
153 */
154 PROCEDURE remap_internal_identifier(
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_old_owner_table_id IN NUMBER,
157 p_new_owner_table_id IN NUMBER,
158 p_owner_table_name IN VARCHAR2,
159 p_orig_system IN VARCHAR2,
160 p_orig_system_reference IN VARCHAR2,
161 p_reason_code IN VARCHAR2,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166
167 procedure get_owner_table_id(p_orig_system in varchar2,
168 p_orig_system_reference in varchar2,
169 p_owner_table_name in varchar2,
170 x_owner_table_id out nocopy number,
171 x_return_status out nocopy varchar2);
172
173
174 END HZ_ORIG_SYSTEM_REF_PUB;