[Home] [Help]
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT
Source
1 PACKAGE HZ_ORIG_SYSTEM_REF_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHMOSRS.pls 120.6 2006/05/31 12:20:51 idali noship $ */
3
4 -- SSM SST Integration and Extension Project
5 TYPE orig_sys_rec_type IS RECORD (
6 orig_system_id NUMBER,
7 orig_system VARCHAR2(30),
8 orig_system_name VARCHAR2(80),
9 description VARCHAR2(240),
10 orig_system_type VARCHAR2(30),
11 sst_flag VARCHAR2(1),
12 status VARCHAR2(1),
13 created_by_module VARCHAR2(150),
14 attribute_category VARCHAR2(30),
15 attribute1 VARCHAR2(150),
16 attribute2 VARCHAR2(150),
17 attribute3 VARCHAR2(150),
18 attribute4 VARCHAR2(150),
19 attribute5 VARCHAR2(150),
20 attribute6 VARCHAR2(150),
21 attribute7 VARCHAR2(150),
22 attribute8 VARCHAR2(150),
23 attribute9 VARCHAR2(150),
24 attribute10 VARCHAR2(150),
25 attribute11 VARCHAR2(150),
26 attribute12 VARCHAR2(150),
27 attribute13 VARCHAR2(150),
28 attribute14 VARCHAR2(150),
29 attribute15 VARCHAR2(150),
30 attribute16 VARCHAR2(150),
31 attribute17 VARCHAR2(150),
32 attribute18 VARCHAR2(150),
33 attribute19 VARCHAR2(150),
34 attribute20 VARCHAR2(150)
35 );
36
37
38 /* This is private API and should be only called in HTML admin UI */
39 PROCEDURE create_orig_sys_entity_mapping(
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 /* This is private API and should be only called in HTML admin UI */
49 PROCEDURE update_orig_sys_entity_mapping(
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52 p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
53 p_object_version_number IN OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60 PROCEDURE create_orig_system_reference(
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE update_orig_system_reference(
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
73 p_object_version_number IN OUT NOCOPY NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 /* only called in hz_customer_acct_merge_v2pvt, bypassed validation */
80 PROCEDURE create_mosr_for_merge(
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 p_owner_table_name IN VARCHAR2,
83 p_owner_table_id IN NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE remap_internal_identifier(
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 p_old_owner_table_id IN NUMBER,
93 p_new_owner_table_id IN NUMBER,
94 p_owner_table_name IN VARCHAR2,
95 p_orig_system IN VARCHAR2,
96 p_orig_system_reference IN VARCHAR2,
97 p_reason_code IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE get_orig_sys_reference_rec (
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_orig_system_ref_id in number,
106 x_orig_sys_reference_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 --raji
113 PROCEDURE get_party_id( p_owner_table_id IN NUMBER,
114 p_owner_table_name IN VARCHAR2,
115 x_party_id OUT NOCOPY NUMBER
116 );
117
118 --This function is invoked in Request Summary, Address, relationships UI to display the Source system count
119 FUNCTION get_source_system_count( p_owner_table_name IN VARCHAR2,
120 p_owner_table_id IN NUMBER) return Number;
121
122
123 -- SSM SST Integration and Extension Project
124
125 PROCEDURE create_orig_system(
126 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128 p_orig_sys_rec IN ORIG_SYS_REC_TYPE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE update_orig_system(
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137 p_orig_sys_rec IN ORIG_SYS_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 END HZ_ORIG_SYSTEM_REF_PVT;