APPS.OZF_MASS_SETTLEMENT_PVT_W dependencies on JTF_NUMBER_TABLE

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

1: package ozf_mass_settlement_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwmsts.pls 120.8 2010/12/27 05:30:31 hbandi ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: ozfwmsts.pls 120.8 2010/12/27 05:30:31 hbandi ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000
8: );
9: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000
8: );
9: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 12: , a3 out nocopy JTF_NUMBER_TABLE

8: );
9: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
14: );
15:
16: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE

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

12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
14: );
15:
16: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
14: );
15:
16: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE

Line 23: , a1 out nocopy JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE
27: );

Line 26: , a4 out nocopy JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
30: , a1 JTF_DATE_TABLE

Line 31: , a2 JTF_NUMBER_TABLE

27: );
28:
29: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
30: , a1 JTF_DATE_TABLE
31: , a2 JTF_NUMBER_TABLE
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_NUMBER_TABLE
34: , a5 JTF_VARCHAR2_TABLE_2000
35: );

Line 32: , a3 JTF_NUMBER_TABLE

28:
29: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
30: , a1 JTF_DATE_TABLE
31: , a2 JTF_NUMBER_TABLE
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_NUMBER_TABLE
34: , a5 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: , a4 JTF_NUMBER_TABLE

29: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
30: , a1 JTF_DATE_TABLE
31: , a2 JTF_NUMBER_TABLE
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_NUMBER_TABLE
34: , a5 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_DATE_TABLE

Line 38: , a2 out nocopy JTF_NUMBER_TABLE

34: , a5 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_DATE_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
42: );

Line 39: , a3 out nocopy JTF_NUMBER_TABLE

35: );
36: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_DATE_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
42: );
43:

Line 40: , a4 out nocopy JTF_NUMBER_TABLE

36: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_DATE_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
42: );
43:
44: procedure settle_mass_settlement(p_api_version NUMBER

Line 62: , p8_a0 JTF_NUMBER_TABLE

58: , p7_a7 VARCHAR2
59: , p7_a8 NUMBER
60: , p7_a9 NUMBER
61: , p7_a10 VARCHAR2
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_VARCHAR2_TABLE_100
64: , p8_a2 JTF_VARCHAR2_TABLE_100
65: , p8_a3 JTF_NUMBER_TABLE
66: , p8_a4 JTF_VARCHAR2_TABLE_2000

Line 65: , p8_a3 JTF_NUMBER_TABLE

61: , p7_a10 VARCHAR2
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_VARCHAR2_TABLE_100
64: , p8_a2 JTF_VARCHAR2_TABLE_100
65: , p8_a3 JTF_NUMBER_TABLE
66: , p8_a4 JTF_VARCHAR2_TABLE_2000
67: , p9_a0 JTF_NUMBER_TABLE
68: , p9_a1 JTF_NUMBER_TABLE
69: , p9_a2 JTF_VARCHAR2_TABLE_100

Line 67: , p9_a0 JTF_NUMBER_TABLE

63: , p8_a1 JTF_VARCHAR2_TABLE_100
64: , p8_a2 JTF_VARCHAR2_TABLE_100
65: , p8_a3 JTF_NUMBER_TABLE
66: , p8_a4 JTF_VARCHAR2_TABLE_2000
67: , p9_a0 JTF_NUMBER_TABLE
68: , p9_a1 JTF_NUMBER_TABLE
69: , p9_a2 JTF_VARCHAR2_TABLE_100
70: , p9_a3 JTF_VARCHAR2_TABLE_100
71: , p9_a4 JTF_NUMBER_TABLE

Line 68: , p9_a1 JTF_NUMBER_TABLE

64: , p8_a2 JTF_VARCHAR2_TABLE_100
65: , p8_a3 JTF_NUMBER_TABLE
66: , p8_a4 JTF_VARCHAR2_TABLE_2000
67: , p9_a0 JTF_NUMBER_TABLE
68: , p9_a1 JTF_NUMBER_TABLE
69: , p9_a2 JTF_VARCHAR2_TABLE_100
70: , p9_a3 JTF_VARCHAR2_TABLE_100
71: , p9_a4 JTF_NUMBER_TABLE
72: , p10_a0 JTF_VARCHAR2_TABLE_100

Line 71: , p9_a4 JTF_NUMBER_TABLE

67: , p9_a0 JTF_NUMBER_TABLE
68: , p9_a1 JTF_NUMBER_TABLE
69: , p9_a2 JTF_VARCHAR2_TABLE_100
70: , p9_a3 JTF_VARCHAR2_TABLE_100
71: , p9_a4 JTF_NUMBER_TABLE
72: , p10_a0 JTF_VARCHAR2_TABLE_100
73: , p10_a1 JTF_DATE_TABLE
74: , p10_a2 JTF_NUMBER_TABLE
75: , p10_a3 JTF_NUMBER_TABLE

Line 74: , p10_a2 JTF_NUMBER_TABLE

70: , p9_a3 JTF_VARCHAR2_TABLE_100
71: , p9_a4 JTF_NUMBER_TABLE
72: , p10_a0 JTF_VARCHAR2_TABLE_100
73: , p10_a1 JTF_DATE_TABLE
74: , p10_a2 JTF_NUMBER_TABLE
75: , p10_a3 JTF_NUMBER_TABLE
76: , p10_a4 JTF_NUMBER_TABLE
77: , p10_a5 JTF_VARCHAR2_TABLE_2000
78: , x_claim_group_id out nocopy NUMBER

Line 75: , p10_a3 JTF_NUMBER_TABLE

71: , p9_a4 JTF_NUMBER_TABLE
72: , p10_a0 JTF_VARCHAR2_TABLE_100
73: , p10_a1 JTF_DATE_TABLE
74: , p10_a2 JTF_NUMBER_TABLE
75: , p10_a3 JTF_NUMBER_TABLE
76: , p10_a4 JTF_NUMBER_TABLE
77: , p10_a5 JTF_VARCHAR2_TABLE_2000
78: , x_claim_group_id out nocopy NUMBER
79: , x_claim_group_number out nocopy VARCHAR2

Line 76: , p10_a4 JTF_NUMBER_TABLE

72: , p10_a0 JTF_VARCHAR2_TABLE_100
73: , p10_a1 JTF_DATE_TABLE
74: , p10_a2 JTF_NUMBER_TABLE
75: , p10_a3 JTF_NUMBER_TABLE
76: , p10_a4 JTF_NUMBER_TABLE
77: , p10_a5 JTF_VARCHAR2_TABLE_2000
78: , x_claim_group_id out nocopy NUMBER
79: , x_claim_group_number out nocopy VARCHAR2
80: );