DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT_W dependencies on OZF_MASS_SETTLEMENT_PVT

Line 1: package body ozf_mass_settlement_pvt_w as

1: package body ozf_mass_settlement_pvt_w as
2: /* $Header: ozfwmstb.pls 120.6 2010/11/23 10:16:22 hbandi 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_2000

Line 43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p2;
43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_NUMBER_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE

83: end if;
84: end if;
85: end rosetta_table_copy_out_p2;
86:
87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE

Line 114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE

110: end loop;
111: end if;
112: end if;
113: end rosetta_table_copy_in_p4;
114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE

Line 158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100

154: end if;
155: end if;
156: end rosetta_table_copy_out_p4;
157:
158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_DATE_TABLE
160: , a2 JTF_NUMBER_TABLE
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE

Line 187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

183: end loop;
184: end if;
185: end if;
186: end rosetta_table_copy_in_p6;
187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_DATE_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE

Line 275: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;

271: , x_claim_group_number out nocopy VARCHAR2
272: )
273:
274: as
275: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
276: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
277: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
278: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
279: ddindx binary_integer; indx binary_integer;

Line 276: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;

272: )
273:
274: as
275: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
276: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
277: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
278: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
279: ddindx binary_integer; indx binary_integer;
280: begin

Line 277: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;

273:
274: as
275: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
276: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
277: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
278: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
279: ddindx binary_integer; indx binary_integer;
280: begin
281:

Line 278: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;

274: as
275: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
276: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
277: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
278: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
279: ddindx binary_integer; indx binary_integer;
280: begin
281:
282: -- copy data to the local IN or IN-OUT args, if any

Line 302: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p2(ddp_open_claim_tbl, p8_a0

298: ddp_group_claim_rec.bill_to_site_id := p7_a8;
299: ddp_group_claim_rec.org_id := p7_a9;
300: ddp_group_claim_rec.comments := p7_a10;
301:
302: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p2(ddp_open_claim_tbl, p8_a0
303: , p8_a1
304: , p8_a2
305: , p8_a3
306: , p8_a4

Line 309: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p4(ddp_open_transaction_tbl, p9_a0

305: , p8_a3
306: , p8_a4
307: );
308:
309: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p4(ddp_open_transaction_tbl, p9_a0
310: , p9_a1
311: , p9_a2
312: , p9_a3
313: , p9_a4

Line 316: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p6(ddp_payment_method_tbl, p10_a0

312: , p9_a3
313: , p9_a4
314: );
315:
316: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p6(ddp_payment_method_tbl, p10_a0
317: , p10_a1
318: , p10_a2
319: , p10_a3
320: , p10_a4

Line 327: ozf_mass_settlement_pvt.settle_mass_settlement(p_api_version,

323:
324:
325:
326: -- here's the delegated call to the old PL/SQL routine
327: ozf_mass_settlement_pvt.settle_mass_settlement(p_api_version,
328: p_init_msg_list,
329: p_commit,
330: p_validation_level,
331: x_return_status,

Line 356: end ozf_mass_settlement_pvt_w;

352:
353:
354: end;
355:
356: end ozf_mass_settlement_pvt_w;