DBA Data[Home] [Help]

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 as
2: /* $Header: ozfwmsts.pls 120.5.12010000.2 2008/08/01 06:23:25 bkunjan 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: );

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: ozfwmsts.pls 120.5.12010000.2 2008/08/01 06:23:25 bkunjan 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: );
8: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_VARCHAR2_TABLE_100
10: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

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

Line 11: , a3 out nocopy JTF_NUMBER_TABLE

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

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

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

Line 15: , a1 JTF_NUMBER_TABLE

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

Line 18: , a4 JTF_NUMBER_TABLE

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

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

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

Line 21: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 24: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 29: , a2 JTF_NUMBER_TABLE

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

Line 30: , a3 JTF_NUMBER_TABLE

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

Line 31: , a4 JTF_NUMBER_TABLE

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

Line 35: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 36: , a3 out nocopy JTF_NUMBER_TABLE

32: );
33: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
34: , a1 out nocopy JTF_DATE_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: );
39:
40: procedure settle_mass_settlement(p_api_version NUMBER

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
34: , a1 out nocopy JTF_DATE_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: );
39:
40: procedure settle_mass_settlement(p_api_version NUMBER
41: , p_init_msg_list VARCHAR2

Line 57: , p8_a0 JTF_NUMBER_TABLE

53: , p7_a6 NUMBER
54: , p7_a7 VARCHAR2
55: , p7_a8 NUMBER
56: , p7_a9 NUMBER
57: , p8_a0 JTF_NUMBER_TABLE
58: , p8_a1 JTF_VARCHAR2_TABLE_100
59: , p8_a2 JTF_VARCHAR2_TABLE_100
60: , p8_a3 JTF_NUMBER_TABLE
61: , p9_a0 JTF_NUMBER_TABLE

Line 60: , p8_a3 JTF_NUMBER_TABLE

56: , p7_a9 NUMBER
57: , p8_a0 JTF_NUMBER_TABLE
58: , p8_a1 JTF_VARCHAR2_TABLE_100
59: , p8_a2 JTF_VARCHAR2_TABLE_100
60: , p8_a3 JTF_NUMBER_TABLE
61: , p9_a0 JTF_NUMBER_TABLE
62: , p9_a1 JTF_NUMBER_TABLE
63: , p9_a2 JTF_VARCHAR2_TABLE_100
64: , p9_a3 JTF_VARCHAR2_TABLE_100

Line 61: , p9_a0 JTF_NUMBER_TABLE

57: , p8_a0 JTF_NUMBER_TABLE
58: , p8_a1 JTF_VARCHAR2_TABLE_100
59: , p8_a2 JTF_VARCHAR2_TABLE_100
60: , p8_a3 JTF_NUMBER_TABLE
61: , p9_a0 JTF_NUMBER_TABLE
62: , p9_a1 JTF_NUMBER_TABLE
63: , p9_a2 JTF_VARCHAR2_TABLE_100
64: , p9_a3 JTF_VARCHAR2_TABLE_100
65: , p9_a4 JTF_NUMBER_TABLE

Line 62: , p9_a1 JTF_NUMBER_TABLE

58: , p8_a1 JTF_VARCHAR2_TABLE_100
59: , p8_a2 JTF_VARCHAR2_TABLE_100
60: , p8_a3 JTF_NUMBER_TABLE
61: , p9_a0 JTF_NUMBER_TABLE
62: , p9_a1 JTF_NUMBER_TABLE
63: , p9_a2 JTF_VARCHAR2_TABLE_100
64: , p9_a3 JTF_VARCHAR2_TABLE_100
65: , p9_a4 JTF_NUMBER_TABLE
66: , p10_a0 JTF_VARCHAR2_TABLE_100

Line 65: , p9_a4 JTF_NUMBER_TABLE

61: , p9_a0 JTF_NUMBER_TABLE
62: , p9_a1 JTF_NUMBER_TABLE
63: , p9_a2 JTF_VARCHAR2_TABLE_100
64: , p9_a3 JTF_VARCHAR2_TABLE_100
65: , p9_a4 JTF_NUMBER_TABLE
66: , p10_a0 JTF_VARCHAR2_TABLE_100
67: , p10_a1 JTF_DATE_TABLE
68: , p10_a2 JTF_NUMBER_TABLE
69: , p10_a3 JTF_NUMBER_TABLE

Line 68: , p10_a2 JTF_NUMBER_TABLE

64: , p9_a3 JTF_VARCHAR2_TABLE_100
65: , p9_a4 JTF_NUMBER_TABLE
66: , p10_a0 JTF_VARCHAR2_TABLE_100
67: , p10_a1 JTF_DATE_TABLE
68: , p10_a2 JTF_NUMBER_TABLE
69: , p10_a3 JTF_NUMBER_TABLE
70: , p10_a4 JTF_NUMBER_TABLE
71: , x_claim_group_id out nocopy NUMBER
72: , x_claim_group_number out nocopy VARCHAR2

Line 69: , p10_a3 JTF_NUMBER_TABLE

65: , p9_a4 JTF_NUMBER_TABLE
66: , p10_a0 JTF_VARCHAR2_TABLE_100
67: , p10_a1 JTF_DATE_TABLE
68: , p10_a2 JTF_NUMBER_TABLE
69: , p10_a3 JTF_NUMBER_TABLE
70: , p10_a4 JTF_NUMBER_TABLE
71: , x_claim_group_id out nocopy NUMBER
72: , x_claim_group_number out nocopy VARCHAR2
73: );

Line 70: , p10_a4 JTF_NUMBER_TABLE

66: , p10_a0 JTF_VARCHAR2_TABLE_100
67: , p10_a1 JTF_DATE_TABLE
68: , p10_a2 JTF_NUMBER_TABLE
69: , p10_a3 JTF_NUMBER_TABLE
70: , p10_a4 JTF_NUMBER_TABLE
71: , x_claim_group_id out nocopy NUMBER
72: , x_claim_group_number out nocopy VARCHAR2
73: );
74: end ozf_mass_settlement_pvt_w;