APPS.OZF_CLAIM_ACCRUAL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE

1: package ozf_claim_accrual_pvt_w as
2: /* $Header: ozfwcacs.pls 120.5 2006/08/11 08:04:25 azahmed noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ozf_claim_accrual_pvt_w as
2: /* $Header: ozfwcacs.pls 120.5 2006/08/11 08:04:25 azahmed noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: ozfwcacs.pls 120.5 2006/08/11 08:04:25 azahmed noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_NUMBER_TABLE

15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE

Line 20: , a17 JTF_NUMBER_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE

Line 21: , a18 JTF_NUMBER_TABLE

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE

Line 23: , a20 JTF_NUMBER_TABLE

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE

Line 24: , a21 JTF_NUMBER_TABLE

20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE

Line 30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE

Line 31: , a1 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE

Line 33: , a3 out nocopy JTF_NUMBER_TABLE

29: );
30: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE

Line 35: , a5 out nocopy JTF_NUMBER_TABLE

31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_NUMBER_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE

Line 36: , a6 out nocopy JTF_NUMBER_TABLE

32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_NUMBER_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a7 out nocopy JTF_NUMBER_TABLE

33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_NUMBER_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_100
41: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a8 out nocopy JTF_NUMBER_TABLE

34: , a4 out nocopy JTF_DATE_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_NUMBER_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_100
41: , a11 out nocopy JTF_VARCHAR2_TABLE_100
42: , a12 out nocopy JTF_DATE_TABLE

Line 39: , a9 out nocopy JTF_NUMBER_TABLE

35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_NUMBER_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_100
41: , a11 out nocopy JTF_VARCHAR2_TABLE_100
42: , a12 out nocopy JTF_DATE_TABLE
43: , a13 out nocopy JTF_NUMBER_TABLE

Line 43: , a13 out nocopy JTF_NUMBER_TABLE

39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_100
41: , a11 out nocopy JTF_VARCHAR2_TABLE_100
42: , a12 out nocopy JTF_DATE_TABLE
43: , a13 out nocopy JTF_NUMBER_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE

Line 44: , a14 out nocopy JTF_NUMBER_TABLE

40: , a10 out nocopy JTF_VARCHAR2_TABLE_100
41: , a11 out nocopy JTF_VARCHAR2_TABLE_100
42: , a12 out nocopy JTF_DATE_TABLE
43: , a13 out nocopy JTF_NUMBER_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE

Line 45: , a15 out nocopy JTF_NUMBER_TABLE

41: , a11 out nocopy JTF_VARCHAR2_TABLE_100
42: , a12 out nocopy JTF_DATE_TABLE
43: , a13 out nocopy JTF_NUMBER_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a16 out nocopy JTF_NUMBER_TABLE

42: , a12 out nocopy JTF_DATE_TABLE
43: , a13 out nocopy JTF_NUMBER_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE

Line 47: , a17 out nocopy JTF_NUMBER_TABLE

43: , a13 out nocopy JTF_NUMBER_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE

Line 48: , a18 out nocopy JTF_NUMBER_TABLE

44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE
46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE

Line 50: , a20 out nocopy JTF_NUMBER_TABLE

46: , a16 out nocopy JTF_NUMBER_TABLE
47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE

Line 51: , a21 out nocopy JTF_NUMBER_TABLE

47: , a17 out nocopy JTF_NUMBER_TABLE
48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 52: , a22 out nocopy JTF_NUMBER_TABLE

48: , a18 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );

Line 53: , a23 out nocopy JTF_NUMBER_TABLE

49: , a19 out nocopy JTF_VARCHAR2_TABLE_100
50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );
57:

Line 54: , a24 out nocopy JTF_NUMBER_TABLE

50: , a20 out nocopy JTF_NUMBER_TABLE
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_NUMBER_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );
57:
58: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE

Line 58: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE

54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );
57:
58: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_300
62: , a4 JTF_DATE_TABLE

Line 59: , a1 JTF_NUMBER_TABLE

55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );
57:
58: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_300
62: , a4 JTF_DATE_TABLE
63: , a5 JTF_DATE_TABLE

Line 65: , a7 JTF_NUMBER_TABLE

61: , a3 JTF_VARCHAR2_TABLE_300
62: , a4 JTF_DATE_TABLE
63: , a5 JTF_DATE_TABLE
64: , a6 JTF_VARCHAR2_TABLE_100
65: , a7 JTF_NUMBER_TABLE
66: , a8 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

64: , a6 JTF_VARCHAR2_TABLE_100
65: , a7 JTF_NUMBER_TABLE
66: , a8 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_300
72: , a4 out nocopy JTF_DATE_TABLE

Line 69: , a1 out nocopy JTF_NUMBER_TABLE

65: , a7 JTF_NUMBER_TABLE
66: , a8 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_300
72: , a4 out nocopy JTF_DATE_TABLE
73: , a5 out nocopy JTF_DATE_TABLE

Line 75: , a7 out nocopy JTF_NUMBER_TABLE

71: , a3 out nocopy JTF_VARCHAR2_TABLE_300
72: , a4 out nocopy JTF_DATE_TABLE
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: );
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE

Line 79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE

75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: );
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE

Line 80: , a1 JTF_NUMBER_TABLE

76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: );
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: );

Line 82: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

78:
79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure get_utiz_sql_stmt(p_api_version NUMBER

Line 83: , a1 out nocopy JTF_NUMBER_TABLE

79: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure get_utiz_sql_stmt(p_api_version NUMBER
87: , p_init_msg_list VARCHAR2

Line 140: , p7_a0 JTF_NUMBER_TABLE

136: , p_validation_level NUMBER
137: , x_return_status out nocopy VARCHAR2
138: , x_msg_data out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , p7_a0 JTF_NUMBER_TABLE
141: , p7_a1 JTF_NUMBER_TABLE
142: , p7_a2 JTF_DATE_TABLE
143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE

Line 141: , p7_a1 JTF_NUMBER_TABLE

137: , x_return_status out nocopy VARCHAR2
138: , x_msg_data out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , p7_a0 JTF_NUMBER_TABLE
141: , p7_a1 JTF_NUMBER_TABLE
142: , p7_a2 JTF_DATE_TABLE
143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE

Line 143: , p7_a3 JTF_NUMBER_TABLE

139: , x_msg_count out nocopy NUMBER
140: , p7_a0 JTF_NUMBER_TABLE
141: , p7_a1 JTF_NUMBER_TABLE
142: , p7_a2 JTF_DATE_TABLE
143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE

Line 145: , p7_a5 JTF_NUMBER_TABLE

141: , p7_a1 JTF_NUMBER_TABLE
142: , p7_a2 JTF_DATE_TABLE
143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE
148: , p7_a8 JTF_NUMBER_TABLE
149: , p7_a9 JTF_NUMBER_TABLE

Line 146: , p7_a6 JTF_NUMBER_TABLE

142: , p7_a2 JTF_DATE_TABLE
143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE
148: , p7_a8 JTF_NUMBER_TABLE
149: , p7_a9 JTF_NUMBER_TABLE
150: , p7_a10 JTF_VARCHAR2_TABLE_100

Line 147: , p7_a7 JTF_NUMBER_TABLE

143: , p7_a3 JTF_NUMBER_TABLE
144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE
148: , p7_a8 JTF_NUMBER_TABLE
149: , p7_a9 JTF_NUMBER_TABLE
150: , p7_a10 JTF_VARCHAR2_TABLE_100
151: , p7_a11 JTF_VARCHAR2_TABLE_100

Line 148: , p7_a8 JTF_NUMBER_TABLE

144: , p7_a4 JTF_DATE_TABLE
145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE
148: , p7_a8 JTF_NUMBER_TABLE
149: , p7_a9 JTF_NUMBER_TABLE
150: , p7_a10 JTF_VARCHAR2_TABLE_100
151: , p7_a11 JTF_VARCHAR2_TABLE_100
152: , p7_a12 JTF_DATE_TABLE

Line 149: , p7_a9 JTF_NUMBER_TABLE

145: , p7_a5 JTF_NUMBER_TABLE
146: , p7_a6 JTF_NUMBER_TABLE
147: , p7_a7 JTF_NUMBER_TABLE
148: , p7_a8 JTF_NUMBER_TABLE
149: , p7_a9 JTF_NUMBER_TABLE
150: , p7_a10 JTF_VARCHAR2_TABLE_100
151: , p7_a11 JTF_VARCHAR2_TABLE_100
152: , p7_a12 JTF_DATE_TABLE
153: , p7_a13 JTF_NUMBER_TABLE

Line 153: , p7_a13 JTF_NUMBER_TABLE

149: , p7_a9 JTF_NUMBER_TABLE
150: , p7_a10 JTF_VARCHAR2_TABLE_100
151: , p7_a11 JTF_VARCHAR2_TABLE_100
152: , p7_a12 JTF_DATE_TABLE
153: , p7_a13 JTF_NUMBER_TABLE
154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE

Line 154: , p7_a14 JTF_NUMBER_TABLE

150: , p7_a10 JTF_VARCHAR2_TABLE_100
151: , p7_a11 JTF_VARCHAR2_TABLE_100
152: , p7_a12 JTF_DATE_TABLE
153: , p7_a13 JTF_NUMBER_TABLE
154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE

Line 155: , p7_a15 JTF_NUMBER_TABLE

151: , p7_a11 JTF_VARCHAR2_TABLE_100
152: , p7_a12 JTF_DATE_TABLE
153: , p7_a13 JTF_NUMBER_TABLE
154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100

Line 156: , p7_a16 JTF_NUMBER_TABLE

152: , p7_a12 JTF_DATE_TABLE
153: , p7_a13 JTF_NUMBER_TABLE
154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE

Line 157: , p7_a17 JTF_NUMBER_TABLE

153: , p7_a13 JTF_NUMBER_TABLE
154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE

Line 158: , p7_a18 JTF_NUMBER_TABLE

154: , p7_a14 JTF_NUMBER_TABLE
155: , p7_a15 JTF_NUMBER_TABLE
156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE

Line 160: , p7_a20 JTF_NUMBER_TABLE

156: , p7_a16 JTF_NUMBER_TABLE
157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE
163: , p7_a23 JTF_NUMBER_TABLE
164: , p7_a24 JTF_NUMBER_TABLE

Line 161: , p7_a21 JTF_NUMBER_TABLE

157: , p7_a17 JTF_NUMBER_TABLE
158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE
163: , p7_a23 JTF_NUMBER_TABLE
164: , p7_a24 JTF_NUMBER_TABLE
165: , p7_a25 JTF_VARCHAR2_TABLE_100

Line 162: , p7_a22 JTF_NUMBER_TABLE

158: , p7_a18 JTF_NUMBER_TABLE
159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE
163: , p7_a23 JTF_NUMBER_TABLE
164: , p7_a24 JTF_NUMBER_TABLE
165: , p7_a25 JTF_VARCHAR2_TABLE_100
166: , p_mode VARCHAR2

Line 163: , p7_a23 JTF_NUMBER_TABLE

159: , p7_a19 JTF_VARCHAR2_TABLE_100
160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE
163: , p7_a23 JTF_NUMBER_TABLE
164: , p7_a24 JTF_NUMBER_TABLE
165: , p7_a25 JTF_VARCHAR2_TABLE_100
166: , p_mode VARCHAR2
167: , x_error_index out nocopy NUMBER

Line 164: , p7_a24 JTF_NUMBER_TABLE

160: , p7_a20 JTF_NUMBER_TABLE
161: , p7_a21 JTF_NUMBER_TABLE
162: , p7_a22 JTF_NUMBER_TABLE
163: , p7_a23 JTF_NUMBER_TABLE
164: , p7_a24 JTF_NUMBER_TABLE
165: , p7_a25 JTF_VARCHAR2_TABLE_100
166: , p_mode VARCHAR2
167: , x_error_index out nocopy NUMBER
168: );

Line 212: , p7_a0 JTF_NUMBER_TABLE

208: , p_validation_level NUMBER
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_data out nocopy VARCHAR2
211: , x_msg_count out nocopy NUMBER
212: , p7_a0 JTF_NUMBER_TABLE
213: , p7_a1 JTF_NUMBER_TABLE
214: , p7_a2 JTF_DATE_TABLE
215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE

Line 213: , p7_a1 JTF_NUMBER_TABLE

209: , x_return_status out nocopy VARCHAR2
210: , x_msg_data out nocopy VARCHAR2
211: , x_msg_count out nocopy NUMBER
212: , p7_a0 JTF_NUMBER_TABLE
213: , p7_a1 JTF_NUMBER_TABLE
214: , p7_a2 JTF_DATE_TABLE
215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE

Line 215: , p7_a3 JTF_NUMBER_TABLE

211: , x_msg_count out nocopy NUMBER
212: , p7_a0 JTF_NUMBER_TABLE
213: , p7_a1 JTF_NUMBER_TABLE
214: , p7_a2 JTF_DATE_TABLE
215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE

Line 217: , p7_a5 JTF_NUMBER_TABLE

213: , p7_a1 JTF_NUMBER_TABLE
214: , p7_a2 JTF_DATE_TABLE
215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE
220: , p7_a8 JTF_NUMBER_TABLE
221: , p7_a9 JTF_NUMBER_TABLE

Line 218: , p7_a6 JTF_NUMBER_TABLE

214: , p7_a2 JTF_DATE_TABLE
215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE
220: , p7_a8 JTF_NUMBER_TABLE
221: , p7_a9 JTF_NUMBER_TABLE
222: , p7_a10 JTF_VARCHAR2_TABLE_100

Line 219: , p7_a7 JTF_NUMBER_TABLE

215: , p7_a3 JTF_NUMBER_TABLE
216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE
220: , p7_a8 JTF_NUMBER_TABLE
221: , p7_a9 JTF_NUMBER_TABLE
222: , p7_a10 JTF_VARCHAR2_TABLE_100
223: , p7_a11 JTF_VARCHAR2_TABLE_100

Line 220: , p7_a8 JTF_NUMBER_TABLE

216: , p7_a4 JTF_DATE_TABLE
217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE
220: , p7_a8 JTF_NUMBER_TABLE
221: , p7_a9 JTF_NUMBER_TABLE
222: , p7_a10 JTF_VARCHAR2_TABLE_100
223: , p7_a11 JTF_VARCHAR2_TABLE_100
224: , p7_a12 JTF_DATE_TABLE

Line 221: , p7_a9 JTF_NUMBER_TABLE

217: , p7_a5 JTF_NUMBER_TABLE
218: , p7_a6 JTF_NUMBER_TABLE
219: , p7_a7 JTF_NUMBER_TABLE
220: , p7_a8 JTF_NUMBER_TABLE
221: , p7_a9 JTF_NUMBER_TABLE
222: , p7_a10 JTF_VARCHAR2_TABLE_100
223: , p7_a11 JTF_VARCHAR2_TABLE_100
224: , p7_a12 JTF_DATE_TABLE
225: , p7_a13 JTF_NUMBER_TABLE

Line 225: , p7_a13 JTF_NUMBER_TABLE

221: , p7_a9 JTF_NUMBER_TABLE
222: , p7_a10 JTF_VARCHAR2_TABLE_100
223: , p7_a11 JTF_VARCHAR2_TABLE_100
224: , p7_a12 JTF_DATE_TABLE
225: , p7_a13 JTF_NUMBER_TABLE
226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE

Line 226: , p7_a14 JTF_NUMBER_TABLE

222: , p7_a10 JTF_VARCHAR2_TABLE_100
223: , p7_a11 JTF_VARCHAR2_TABLE_100
224: , p7_a12 JTF_DATE_TABLE
225: , p7_a13 JTF_NUMBER_TABLE
226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE

Line 227: , p7_a15 JTF_NUMBER_TABLE

223: , p7_a11 JTF_VARCHAR2_TABLE_100
224: , p7_a12 JTF_DATE_TABLE
225: , p7_a13 JTF_NUMBER_TABLE
226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100

Line 228: , p7_a16 JTF_NUMBER_TABLE

224: , p7_a12 JTF_DATE_TABLE
225: , p7_a13 JTF_NUMBER_TABLE
226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE

Line 229: , p7_a17 JTF_NUMBER_TABLE

225: , p7_a13 JTF_NUMBER_TABLE
226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE

Line 230: , p7_a18 JTF_NUMBER_TABLE

226: , p7_a14 JTF_NUMBER_TABLE
227: , p7_a15 JTF_NUMBER_TABLE
228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE

Line 232: , p7_a20 JTF_NUMBER_TABLE

228: , p7_a16 JTF_NUMBER_TABLE
229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE
235: , p7_a23 JTF_NUMBER_TABLE
236: , p7_a24 JTF_NUMBER_TABLE

Line 233: , p7_a21 JTF_NUMBER_TABLE

229: , p7_a17 JTF_NUMBER_TABLE
230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE
235: , p7_a23 JTF_NUMBER_TABLE
236: , p7_a24 JTF_NUMBER_TABLE
237: , p7_a25 JTF_VARCHAR2_TABLE_100

Line 234: , p7_a22 JTF_NUMBER_TABLE

230: , p7_a18 JTF_NUMBER_TABLE
231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE
235: , p7_a23 JTF_NUMBER_TABLE
236: , p7_a24 JTF_NUMBER_TABLE
237: , p7_a25 JTF_VARCHAR2_TABLE_100
238: , p_mode VARCHAR2

Line 235: , p7_a23 JTF_NUMBER_TABLE

231: , p7_a19 JTF_VARCHAR2_TABLE_100
232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE
235: , p7_a23 JTF_NUMBER_TABLE
236: , p7_a24 JTF_NUMBER_TABLE
237: , p7_a25 JTF_VARCHAR2_TABLE_100
238: , p_mode VARCHAR2
239: , x_error_index out nocopy NUMBER

Line 236: , p7_a24 JTF_NUMBER_TABLE

232: , p7_a20 JTF_NUMBER_TABLE
233: , p7_a21 JTF_NUMBER_TABLE
234: , p7_a22 JTF_NUMBER_TABLE
235: , p7_a23 JTF_NUMBER_TABLE
236: , p7_a24 JTF_NUMBER_TABLE
237: , p7_a25 JTF_VARCHAR2_TABLE_100
238: , p_mode VARCHAR2
239: , x_error_index out nocopy NUMBER
240: );

Line 284: , p7_a0 JTF_NUMBER_TABLE

280: , p_validation_level NUMBER
281: , x_return_status out nocopy VARCHAR2
282: , x_msg_data out nocopy VARCHAR2
283: , x_msg_count out nocopy NUMBER
284: , p7_a0 JTF_NUMBER_TABLE
285: , p7_a1 JTF_NUMBER_TABLE
286: , p7_a2 JTF_DATE_TABLE
287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE

Line 285: , p7_a1 JTF_NUMBER_TABLE

281: , x_return_status out nocopy VARCHAR2
282: , x_msg_data out nocopy VARCHAR2
283: , x_msg_count out nocopy NUMBER
284: , p7_a0 JTF_NUMBER_TABLE
285: , p7_a1 JTF_NUMBER_TABLE
286: , p7_a2 JTF_DATE_TABLE
287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE

Line 287: , p7_a3 JTF_NUMBER_TABLE

283: , x_msg_count out nocopy NUMBER
284: , p7_a0 JTF_NUMBER_TABLE
285: , p7_a1 JTF_NUMBER_TABLE
286: , p7_a2 JTF_DATE_TABLE
287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE

Line 289: , p7_a5 JTF_NUMBER_TABLE

285: , p7_a1 JTF_NUMBER_TABLE
286: , p7_a2 JTF_DATE_TABLE
287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE
292: , p7_a8 JTF_NUMBER_TABLE
293: , p7_a9 JTF_NUMBER_TABLE

Line 290: , p7_a6 JTF_NUMBER_TABLE

286: , p7_a2 JTF_DATE_TABLE
287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE
292: , p7_a8 JTF_NUMBER_TABLE
293: , p7_a9 JTF_NUMBER_TABLE
294: , p7_a10 JTF_VARCHAR2_TABLE_100

Line 291: , p7_a7 JTF_NUMBER_TABLE

287: , p7_a3 JTF_NUMBER_TABLE
288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE
292: , p7_a8 JTF_NUMBER_TABLE
293: , p7_a9 JTF_NUMBER_TABLE
294: , p7_a10 JTF_VARCHAR2_TABLE_100
295: , p7_a11 JTF_VARCHAR2_TABLE_100

Line 292: , p7_a8 JTF_NUMBER_TABLE

288: , p7_a4 JTF_DATE_TABLE
289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE
292: , p7_a8 JTF_NUMBER_TABLE
293: , p7_a9 JTF_NUMBER_TABLE
294: , p7_a10 JTF_VARCHAR2_TABLE_100
295: , p7_a11 JTF_VARCHAR2_TABLE_100
296: , p7_a12 JTF_DATE_TABLE

Line 293: , p7_a9 JTF_NUMBER_TABLE

289: , p7_a5 JTF_NUMBER_TABLE
290: , p7_a6 JTF_NUMBER_TABLE
291: , p7_a7 JTF_NUMBER_TABLE
292: , p7_a8 JTF_NUMBER_TABLE
293: , p7_a9 JTF_NUMBER_TABLE
294: , p7_a10 JTF_VARCHAR2_TABLE_100
295: , p7_a11 JTF_VARCHAR2_TABLE_100
296: , p7_a12 JTF_DATE_TABLE
297: , p7_a13 JTF_NUMBER_TABLE

Line 297: , p7_a13 JTF_NUMBER_TABLE

293: , p7_a9 JTF_NUMBER_TABLE
294: , p7_a10 JTF_VARCHAR2_TABLE_100
295: , p7_a11 JTF_VARCHAR2_TABLE_100
296: , p7_a12 JTF_DATE_TABLE
297: , p7_a13 JTF_NUMBER_TABLE
298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE

Line 298: , p7_a14 JTF_NUMBER_TABLE

294: , p7_a10 JTF_VARCHAR2_TABLE_100
295: , p7_a11 JTF_VARCHAR2_TABLE_100
296: , p7_a12 JTF_DATE_TABLE
297: , p7_a13 JTF_NUMBER_TABLE
298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE

Line 299: , p7_a15 JTF_NUMBER_TABLE

295: , p7_a11 JTF_VARCHAR2_TABLE_100
296: , p7_a12 JTF_DATE_TABLE
297: , p7_a13 JTF_NUMBER_TABLE
298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100

Line 300: , p7_a16 JTF_NUMBER_TABLE

296: , p7_a12 JTF_DATE_TABLE
297: , p7_a13 JTF_NUMBER_TABLE
298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE

Line 301: , p7_a17 JTF_NUMBER_TABLE

297: , p7_a13 JTF_NUMBER_TABLE
298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE

Line 302: , p7_a18 JTF_NUMBER_TABLE

298: , p7_a14 JTF_NUMBER_TABLE
299: , p7_a15 JTF_NUMBER_TABLE
300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE

Line 304: , p7_a20 JTF_NUMBER_TABLE

300: , p7_a16 JTF_NUMBER_TABLE
301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE
307: , p7_a23 JTF_NUMBER_TABLE
308: , p7_a24 JTF_NUMBER_TABLE

Line 305: , p7_a21 JTF_NUMBER_TABLE

301: , p7_a17 JTF_NUMBER_TABLE
302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE
307: , p7_a23 JTF_NUMBER_TABLE
308: , p7_a24 JTF_NUMBER_TABLE
309: , p7_a25 JTF_VARCHAR2_TABLE_100

Line 306: , p7_a22 JTF_NUMBER_TABLE

302: , p7_a18 JTF_NUMBER_TABLE
303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE
307: , p7_a23 JTF_NUMBER_TABLE
308: , p7_a24 JTF_NUMBER_TABLE
309: , p7_a25 JTF_VARCHAR2_TABLE_100
310: , p_mode VARCHAR2

Line 307: , p7_a23 JTF_NUMBER_TABLE

303: , p7_a19 JTF_VARCHAR2_TABLE_100
304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE
307: , p7_a23 JTF_NUMBER_TABLE
308: , p7_a24 JTF_NUMBER_TABLE
309: , p7_a25 JTF_VARCHAR2_TABLE_100
310: , p_mode VARCHAR2
311: , x_error_index out nocopy NUMBER

Line 308: , p7_a24 JTF_NUMBER_TABLE

304: , p7_a20 JTF_NUMBER_TABLE
305: , p7_a21 JTF_NUMBER_TABLE
306: , p7_a22 JTF_NUMBER_TABLE
307: , p7_a23 JTF_NUMBER_TABLE
308: , p7_a24 JTF_NUMBER_TABLE
309: , p7_a25 JTF_VARCHAR2_TABLE_100
310: , p_mode VARCHAR2
311: , x_error_index out nocopy NUMBER
312: );

Line 951: , p5_a0 out nocopy JTF_NUMBER_TABLE

947: , p_offer_id NUMBER
948: , p_resale_flag VARCHAR2
949: , p_check_all_flag VARCHAR2
950: , x_performance_flag out nocopy VARCHAR2
951: , p5_a0 out nocopy JTF_NUMBER_TABLE
952: , p5_a1 out nocopy JTF_NUMBER_TABLE
953: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
955: , p5_a4 out nocopy JTF_DATE_TABLE

Line 952: , p5_a1 out nocopy JTF_NUMBER_TABLE

948: , p_resale_flag VARCHAR2
949: , p_check_all_flag VARCHAR2
950: , x_performance_flag out nocopy VARCHAR2
951: , p5_a0 out nocopy JTF_NUMBER_TABLE
952: , p5_a1 out nocopy JTF_NUMBER_TABLE
953: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
955: , p5_a4 out nocopy JTF_DATE_TABLE
956: , p5_a5 out nocopy JTF_DATE_TABLE

Line 958: , p5_a7 out nocopy JTF_NUMBER_TABLE

954: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
955: , p5_a4 out nocopy JTF_DATE_TABLE
956: , p5_a5 out nocopy JTF_DATE_TABLE
957: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a7 out nocopy JTF_NUMBER_TABLE
959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: );
961: procedure check_offer_performance_tbl(p_claim_id NUMBER
962: , p1_a0 out nocopy JTF_NUMBER_TABLE

Line 962: , p1_a0 out nocopy JTF_NUMBER_TABLE

958: , p5_a7 out nocopy JTF_NUMBER_TABLE
959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: );
961: procedure check_offer_performance_tbl(p_claim_id NUMBER
962: , p1_a0 out nocopy JTF_NUMBER_TABLE
963: , p1_a1 out nocopy JTF_NUMBER_TABLE
964: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
965: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
966: , p1_a4 out nocopy JTF_DATE_TABLE

Line 963: , p1_a1 out nocopy JTF_NUMBER_TABLE

959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: );
961: procedure check_offer_performance_tbl(p_claim_id NUMBER
962: , p1_a0 out nocopy JTF_NUMBER_TABLE
963: , p1_a1 out nocopy JTF_NUMBER_TABLE
964: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
965: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
966: , p1_a4 out nocopy JTF_DATE_TABLE
967: , p1_a5 out nocopy JTF_DATE_TABLE

Line 969: , p1_a7 out nocopy JTF_NUMBER_TABLE

965: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
966: , p1_a4 out nocopy JTF_DATE_TABLE
967: , p1_a5 out nocopy JTF_DATE_TABLE
968: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
969: , p1_a7 out nocopy JTF_NUMBER_TABLE
970: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
971: );
972: procedure check_offer_earning_tbl(p_claim_id NUMBER
973: , p1_a0 out nocopy JTF_NUMBER_TABLE

Line 973: , p1_a0 out nocopy JTF_NUMBER_TABLE

969: , p1_a7 out nocopy JTF_NUMBER_TABLE
970: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
971: );
972: procedure check_offer_earning_tbl(p_claim_id NUMBER
973: , p1_a0 out nocopy JTF_NUMBER_TABLE
974: , p1_a1 out nocopy JTF_NUMBER_TABLE
975: );
976: function calculate_fxgl_amount(p0_a0 NUMBER
977: , p0_a1 NUMBER

Line 974: , p1_a1 out nocopy JTF_NUMBER_TABLE

970: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
971: );
972: procedure check_offer_earning_tbl(p_claim_id NUMBER
973: , p1_a0 out nocopy JTF_NUMBER_TABLE
974: , p1_a1 out nocopy JTF_NUMBER_TABLE
975: );
976: function calculate_fxgl_amount(p0_a0 NUMBER
977: , p0_a1 NUMBER
978: , p0_a2 DATE