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.4.12010000.2 2008/08/01 06:22:06 bkunjan 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: ) as

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

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p2;
41: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as

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

76: end if;
77: end if;
78: end rosetta_table_copy_out_p2;
79:
80: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE

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

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p4;
107: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE

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

147: end if;
148: end if;
149: end rosetta_table_copy_out_p4;
150:
151: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
152: , a1 JTF_DATE_TABLE
153: , a2 JTF_NUMBER_TABLE
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_NUMBER_TABLE

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

174: end loop;
175: end if;
176: end if;
177: end rosetta_table_copy_in_p6;
178: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
179: , a1 out nocopy JTF_DATE_TABLE
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE

Line 258: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;

254: , x_claim_group_number out nocopy VARCHAR2
255: )
256:
257: as
258: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
259: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
260: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
261: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
262: ddindx binary_integer; indx binary_integer;

Line 259: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;

255: )
256:
257: as
258: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
259: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
260: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
261: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
262: ddindx binary_integer; indx binary_integer;
263: begin

Line 260: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;

256:
257: as
258: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
259: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
260: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
261: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
262: ddindx binary_integer; indx binary_integer;
263: begin
264:

Line 261: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;

257: as
258: ddp_group_claim_rec ozf_mass_settlement_pvt.group_claim_rec;
259: ddp_open_claim_tbl ozf_mass_settlement_pvt.open_claim_tbl;
260: ddp_open_transaction_tbl ozf_mass_settlement_pvt.open_transaction_tbl;
261: ddp_payment_method_tbl ozf_mass_settlement_pvt.claim_payment_method_tbl;
262: ddindx binary_integer; indx binary_integer;
263: begin
264:
265: -- copy data to the local IN or IN-OUT args, if any

Line 284: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p2(ddp_open_claim_tbl, p8_a0

280: ddp_group_claim_rec.currency_code := p7_a7;
281: ddp_group_claim_rec.bill_to_site_id := p7_a8;
282: ddp_group_claim_rec.org_id := p7_a9;
283:
284: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p2(ddp_open_claim_tbl, p8_a0
285: , p8_a1
286: , p8_a2
287: , p8_a3
288: );

Line 290: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p4(ddp_open_transaction_tbl, p9_a0

286: , p8_a2
287: , p8_a3
288: );
289:
290: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p4(ddp_open_transaction_tbl, p9_a0
291: , p9_a1
292: , p9_a2
293: , p9_a3
294: , p9_a4

Line 297: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p6(ddp_payment_method_tbl, p10_a0

293: , p9_a3
294: , p9_a4
295: );
296:
297: ozf_mass_settlement_pvt_w.rosetta_table_copy_in_p6(ddp_payment_method_tbl, p10_a0
298: , p10_a1
299: , p10_a2
300: , p10_a3
301: , p10_a4

Line 307: ozf_mass_settlement_pvt.settle_mass_settlement(p_api_version,

303:
304:
305:
306: -- here's the delegated call to the old PL/SQL routine
307: ozf_mass_settlement_pvt.settle_mass_settlement(p_api_version,
308: p_init_msg_list,
309: p_commit,
310: p_validation_level,
311: x_return_status,

Line 336: end ozf_mass_settlement_pvt_w;

332:
333:
334: end;
335:
336: end ozf_mass_settlement_pvt_w;