DBA Data[Home] [Help]

APPS.HZ_DUP_PVT_W dependencies on HZ_DUP_PVT

Line 1: package body hz_dup_pvt_w as

1: package body hz_dup_pvt_w as
2: /* $Header: ARHWDUPB.pls 120.3 2005/06/18 04:28:09 jhuang ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy hz_dup_pvt.dup_party_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy hz_dup_pvt.dup_party_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE

Line 44: procedure rosetta_table_copy_out_p1(t hz_dup_pvt.dup_party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t hz_dup_pvt.dup_party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_NUMBER_TABLE

Line 117: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;

113: , x_msg_data out nocopy VARCHAR2
114: )
115:
116: as
117: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;
118: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;
119: ddindx binary_integer; indx binary_integer;
120: begin
121:

Line 118: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;

114: )
115:
116: as
117: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;
118: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;
119: ddindx binary_integer; indx binary_integer;
120: begin
121:
122: -- copy data to the local IN or IN-OUT args, if any

Line 129: hz_dup_pvt_w.rosetta_table_copy_in_p1(ddp_dup_party_tbl, p1_a0

125: ddp_dup_set_rec.status := p0_a2;
126: ddp_dup_set_rec.assigned_to_user_id := p0_a3;
127: ddp_dup_set_rec.merge_type := p0_a4;
128:
129: hz_dup_pvt_w.rosetta_table_copy_in_p1(ddp_dup_party_tbl, p1_a0
130: , p1_a1
131: , p1_a2
132: , p1_a3
133: , p1_a4

Line 143: hz_dup_pvt.create_dup_set(ddp_dup_set_rec,

139:
140:
141:
142: -- here's the delegated call to the old PL/SQL routine
143: hz_dup_pvt.create_dup_set(ddp_dup_set_rec,
144: ddp_dup_party_tbl,
145: x_dup_set_id,
146: x_return_status,
147: x_msg_count,

Line 182: ddp_dup_batch_rec hz_dup_pvt.dup_batch_rec_type;

178: , x_msg_data out nocopy VARCHAR2
179: )
180:
181: as
182: ddp_dup_batch_rec hz_dup_pvt.dup_batch_rec_type;
183: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;
184: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;
185: ddindx binary_integer; indx binary_integer;
186: begin

Line 183: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;

179: )
180:
181: as
182: ddp_dup_batch_rec hz_dup_pvt.dup_batch_rec_type;
183: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;
184: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;
185: ddindx binary_integer; indx binary_integer;
186: begin
187:

Line 184: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;

180:
181: as
182: ddp_dup_batch_rec hz_dup_pvt.dup_batch_rec_type;
183: ddp_dup_set_rec hz_dup_pvt.dup_set_rec_type;
184: ddp_dup_party_tbl hz_dup_pvt.dup_party_tbl_type;
185: ddindx binary_integer; indx binary_integer;
186: begin
187:
188: -- copy data to the local IN or IN-OUT args, if any

Line 200: hz_dup_pvt_w.rosetta_table_copy_in_p1(ddp_dup_party_tbl, p2_a0

196: ddp_dup_set_rec.status := p1_a2;
197: ddp_dup_set_rec.assigned_to_user_id := p1_a3;
198: ddp_dup_set_rec.merge_type := p1_a4;
199:
200: hz_dup_pvt_w.rosetta_table_copy_in_p1(ddp_dup_party_tbl, p2_a0
201: , p2_a1
202: , p2_a2
203: , p2_a3
204: , p2_a4

Line 215: hz_dup_pvt.create_dup_batch(ddp_dup_batch_rec,

211:
212:
213:
214: -- here's the delegated call to the old PL/SQL routine
215: hz_dup_pvt.create_dup_batch(ddp_dup_batch_rec,
216: ddp_dup_set_rec,
217: ddp_dup_party_tbl,
218: x_dup_batch_id,
219: x_dup_set_id,

Line 234: end hz_dup_pvt_w;

230:
231:
232: end;
233:
234: end hz_dup_pvt_w;