DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package ahl_prd_disp_util_pvt_w as
2: /* $Header: AHLWDIUS.pls 120.1 2008/01/29 14:17:24 sathapli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package ahl_prd_disp_util_pvt_w as
2: /* $Header: AHLWDIUS.pls 120.1 2008/01/29 14:17:24 sathapli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );

Line 6: procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWDIUS.pls 120.1 2008/01/29 14:17:24 sathapli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 JTF_NUMBER_TABLE

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE

Line 13: , a3 JTF_VARCHAR2_TABLE_100

9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100

Line 15: , a5 JTF_VARCHAR2_TABLE_100

11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100

Line 16: , a6 JTF_VARCHAR2_TABLE_100

12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100

Line 17: , a7 JTF_VARCHAR2_TABLE_100

13: , a3 JTF_VARCHAR2_TABLE_100
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100

Line 18: , a8 JTF_VARCHAR2_TABLE_100

14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE

Line 19: , a9 JTF_VARCHAR2_TABLE_100

15: , a5 JTF_VARCHAR2_TABLE_100
16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_VARCHAR2_TABLE_100

Line 20: , a10 JTF_VARCHAR2_TABLE_100

16: , a6 JTF_VARCHAR2_TABLE_100
17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE

Line 21: , a11 JTF_VARCHAR2_TABLE_100

17: , a7 JTF_VARCHAR2_TABLE_100
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_200

Line 23: , a13 JTF_VARCHAR2_TABLE_100

19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_100
21: , a11 JTF_VARCHAR2_TABLE_100
22: , a12 JTF_NUMBER_TABLE
23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_200
26: , a16 JTF_NUMBER_TABLE
27: , a17 JTF_VARCHAR2_TABLE_100

Line 27: , a17 JTF_VARCHAR2_TABLE_100

23: , a13 JTF_VARCHAR2_TABLE_100
24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_200
26: , a16 JTF_NUMBER_TABLE
27: , a17 JTF_VARCHAR2_TABLE_100
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_VARCHAR2_TABLE_100

Line 28: , a18 JTF_VARCHAR2_TABLE_100

24: , a14 JTF_NUMBER_TABLE
25: , a15 JTF_VARCHAR2_TABLE_200
26: , a16 JTF_NUMBER_TABLE
27: , a17 JTF_VARCHAR2_TABLE_100
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_NUMBER_TABLE

Line 29: , a19 JTF_VARCHAR2_TABLE_100

25: , a15 JTF_VARCHAR2_TABLE_200
26: , a16 JTF_NUMBER_TABLE
27: , a17 JTF_VARCHAR2_TABLE_100
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_NUMBER_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100

Line 31: , a21 JTF_VARCHAR2_TABLE_100

27: , a17 JTF_VARCHAR2_TABLE_100
28: , a18 JTF_VARCHAR2_TABLE_100
29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_NUMBER_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_NUMBER_TABLE
35: , a25 JTF_VARCHAR2_TABLE_100

Line 33: , a23 JTF_VARCHAR2_TABLE_100

29: , a19 JTF_VARCHAR2_TABLE_100
30: , a20 JTF_NUMBER_TABLE
31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_NUMBER_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_NUMBER_TABLE
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100

Line 35: , a25 JTF_VARCHAR2_TABLE_100

31: , a21 JTF_VARCHAR2_TABLE_100
32: , a22 JTF_NUMBER_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_NUMBER_TABLE
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_VARCHAR2_TABLE_100

Line 36: , a26 JTF_VARCHAR2_TABLE_100

32: , a22 JTF_NUMBER_TABLE
33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_NUMBER_TABLE
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_VARCHAR2_TABLE_100
40: );

Line 37: , a27 JTF_VARCHAR2_TABLE_100

33: , a23 JTF_VARCHAR2_TABLE_100
34: , a24 JTF_NUMBER_TABLE
35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_VARCHAR2_TABLE_100
40: );
41: procedure rosetta_table_copy_out_p4(t ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 39: , a29 JTF_VARCHAR2_TABLE_100

35: , a25 JTF_VARCHAR2_TABLE_100
36: , a26 JTF_VARCHAR2_TABLE_100
37: , a27 JTF_VARCHAR2_TABLE_100
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_VARCHAR2_TABLE_100
40: );
41: procedure rosetta_table_copy_out_p4(t ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE

Line 44: , a3 out nocopy JTF_VARCHAR2_TABLE_100

40: );
41: procedure rosetta_table_copy_out_p4(t ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a5 out nocopy JTF_VARCHAR2_TABLE_100

42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a6 out nocopy JTF_VARCHAR2_TABLE_100

43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a7 out nocopy JTF_VARCHAR2_TABLE_100

44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a8 out nocopy JTF_VARCHAR2_TABLE_100

45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_NUMBER_TABLE

Line 50: , a9 out nocopy JTF_VARCHAR2_TABLE_100

46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a10 out nocopy JTF_VARCHAR2_TABLE_100

47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_VARCHAR2_TABLE_100
55: , a14 out nocopy JTF_NUMBER_TABLE

Line 52: , a11 out nocopy JTF_VARCHAR2_TABLE_100

48: , a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_VARCHAR2_TABLE_100
55: , a14 out nocopy JTF_NUMBER_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 54: , a13 out nocopy JTF_VARCHAR2_TABLE_100

50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_VARCHAR2_TABLE_100
55: , a14 out nocopy JTF_NUMBER_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_200
57: , a16 out nocopy JTF_NUMBER_TABLE
58: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a17 out nocopy JTF_VARCHAR2_TABLE_100

54: , a13 out nocopy JTF_VARCHAR2_TABLE_100
55: , a14 out nocopy JTF_NUMBER_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_200
57: , a16 out nocopy JTF_NUMBER_TABLE
58: , a17 out nocopy JTF_VARCHAR2_TABLE_100
59: , a18 out nocopy JTF_VARCHAR2_TABLE_100
60: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a20 out nocopy JTF_NUMBER_TABLE
62: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a18 out nocopy JTF_VARCHAR2_TABLE_100

55: , a14 out nocopy JTF_NUMBER_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_200
57: , a16 out nocopy JTF_NUMBER_TABLE
58: , a17 out nocopy JTF_VARCHAR2_TABLE_100
59: , a18 out nocopy JTF_VARCHAR2_TABLE_100
60: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a20 out nocopy JTF_NUMBER_TABLE
62: , a21 out nocopy JTF_VARCHAR2_TABLE_100
63: , a22 out nocopy JTF_NUMBER_TABLE

Line 60: , a19 out nocopy JTF_VARCHAR2_TABLE_100

56: , a15 out nocopy JTF_VARCHAR2_TABLE_200
57: , a16 out nocopy JTF_NUMBER_TABLE
58: , a17 out nocopy JTF_VARCHAR2_TABLE_100
59: , a18 out nocopy JTF_VARCHAR2_TABLE_100
60: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a20 out nocopy JTF_NUMBER_TABLE
62: , a21 out nocopy JTF_VARCHAR2_TABLE_100
63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a21 out nocopy JTF_VARCHAR2_TABLE_100

58: , a17 out nocopy JTF_VARCHAR2_TABLE_100
59: , a18 out nocopy JTF_VARCHAR2_TABLE_100
60: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a20 out nocopy JTF_NUMBER_TABLE
62: , a21 out nocopy JTF_VARCHAR2_TABLE_100
63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_VARCHAR2_TABLE_100
65: , a24 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a23 out nocopy JTF_VARCHAR2_TABLE_100

60: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a20 out nocopy JTF_NUMBER_TABLE
62: , a21 out nocopy JTF_VARCHAR2_TABLE_100
63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_VARCHAR2_TABLE_100
65: , a24 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_100
67: , a26 out nocopy JTF_VARCHAR2_TABLE_100
68: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a25 out nocopy JTF_VARCHAR2_TABLE_100

62: , a21 out nocopy JTF_VARCHAR2_TABLE_100
63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_VARCHAR2_TABLE_100
65: , a24 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_100
67: , a26 out nocopy JTF_VARCHAR2_TABLE_100
68: , a27 out nocopy JTF_VARCHAR2_TABLE_100
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a26 out nocopy JTF_VARCHAR2_TABLE_100

63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_VARCHAR2_TABLE_100
65: , a24 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_100
67: , a26 out nocopy JTF_VARCHAR2_TABLE_100
68: , a27 out nocopy JTF_VARCHAR2_TABLE_100
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_VARCHAR2_TABLE_100
71: );

Line 68: , a27 out nocopy JTF_VARCHAR2_TABLE_100

64: , a23 out nocopy JTF_VARCHAR2_TABLE_100
65: , a24 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_100
67: , a26 out nocopy JTF_VARCHAR2_TABLE_100
68: , a27 out nocopy JTF_VARCHAR2_TABLE_100
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:

Line 70: , a29 out nocopy JTF_VARCHAR2_TABLE_100

66: , a25 out nocopy JTF_VARCHAR2_TABLE_100
67: , a26 out nocopy JTF_VARCHAR2_TABLE_100
68: , a27 out nocopy JTF_VARCHAR2_TABLE_100
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure get_disposition_list(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2

Line 102: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

98: , x_results_count out nocopy NUMBER
99: , p11_a0 out nocopy JTF_NUMBER_TABLE
100: , p11_a1 out nocopy JTF_NUMBER_TABLE
101: , p11_a2 out nocopy JTF_NUMBER_TABLE
102: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p11_a4 out nocopy JTF_NUMBER_TABLE
104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

100: , p11_a1 out nocopy JTF_NUMBER_TABLE
101: , p11_a2 out nocopy JTF_NUMBER_TABLE
102: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p11_a4 out nocopy JTF_NUMBER_TABLE
104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

101: , p11_a2 out nocopy JTF_NUMBER_TABLE
102: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p11_a4 out nocopy JTF_NUMBER_TABLE
104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

102: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p11_a4 out nocopy JTF_NUMBER_TABLE
104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100

103: , p11_a4 out nocopy JTF_NUMBER_TABLE
104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , p11_a12 out nocopy JTF_NUMBER_TABLE

Line 108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

104: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , p11_a12 out nocopy JTF_NUMBER_TABLE
112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100

105: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , p11_a12 out nocopy JTF_NUMBER_TABLE
112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , p11_a14 out nocopy JTF_NUMBER_TABLE

Line 110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100

106: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , p11_a12 out nocopy JTF_NUMBER_TABLE
112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , p11_a14 out nocopy JTF_NUMBER_TABLE
114: , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

108: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , p11_a12 out nocopy JTF_NUMBER_TABLE
112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , p11_a14 out nocopy JTF_NUMBER_TABLE
114: , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
115: , p11_a16 out nocopy JTF_NUMBER_TABLE
116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100

112: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , p11_a14 out nocopy JTF_NUMBER_TABLE
114: , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
115: , p11_a16 out nocopy JTF_NUMBER_TABLE
116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , p11_a20 out nocopy JTF_NUMBER_TABLE
120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100

113: , p11_a14 out nocopy JTF_NUMBER_TABLE
114: , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
115: , p11_a16 out nocopy JTF_NUMBER_TABLE
116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , p11_a20 out nocopy JTF_NUMBER_TABLE
120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121: , p11_a22 out nocopy JTF_NUMBER_TABLE

Line 118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100

114: , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
115: , p11_a16 out nocopy JTF_NUMBER_TABLE
116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , p11_a20 out nocopy JTF_NUMBER_TABLE
120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121: , p11_a22 out nocopy JTF_NUMBER_TABLE
122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100

116: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , p11_a20 out nocopy JTF_NUMBER_TABLE
120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121: , p11_a22 out nocopy JTF_NUMBER_TABLE
122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , p11_a24 out nocopy JTF_NUMBER_TABLE
124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100

118: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , p11_a20 out nocopy JTF_NUMBER_TABLE
120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121: , p11_a22 out nocopy JTF_NUMBER_TABLE
122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , p11_a24 out nocopy JTF_NUMBER_TABLE
124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100

120: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121: , p11_a22 out nocopy JTF_NUMBER_TABLE
122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , p11_a24 out nocopy JTF_NUMBER_TABLE
124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
127: , p11_a28 out nocopy JTF_NUMBER_TABLE
128: , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100

121: , p11_a22 out nocopy JTF_NUMBER_TABLE
122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , p11_a24 out nocopy JTF_NUMBER_TABLE
124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
127: , p11_a28 out nocopy JTF_NUMBER_TABLE
128: , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100
129: );

Line 126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100

122: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , p11_a24 out nocopy JTF_NUMBER_TABLE
124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
127: , p11_a28 out nocopy JTF_NUMBER_TABLE
128: , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130: procedure get_part_change_disposition(p_api_version NUMBER

Line 128: , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100

124: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
127: , p11_a28 out nocopy JTF_NUMBER_TABLE
128: , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130: procedure get_part_change_disposition(p_api_version NUMBER
131: , p_init_msg_list VARCHAR2
132: , p_commit VARCHAR2

Line 202: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100

198: , p11_a57 out nocopy VARCHAR2
199: , p11_a58 out nocopy VARCHAR2
200: , p11_a59 out nocopy VARCHAR2
201: , p11_a60 out nocopy VARCHAR2
202: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
203: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
204: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
205: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
206: );

Line 203: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

199: , p11_a58 out nocopy VARCHAR2
200: , p11_a59 out nocopy VARCHAR2
201: , p11_a60 out nocopy VARCHAR2
202: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
203: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
204: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
205: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
206: );
207: procedure get_available_disp_types(p_api_version NUMBER

Line 204: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100

200: , p11_a59 out nocopy VARCHAR2
201: , p11_a60 out nocopy VARCHAR2
202: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
203: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
204: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
205: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
206: );
207: procedure get_available_disp_types(p_api_version NUMBER
208: , p_init_msg_list VARCHAR2

Line 205: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100

201: , p11_a60 out nocopy VARCHAR2
202: , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
203: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
204: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
205: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
206: );
207: procedure get_available_disp_types(p_api_version NUMBER
208: , p_init_msg_list VARCHAR2
209: , p_commit VARCHAR2

Line 215: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

211: , x_return_status out nocopy VARCHAR2
212: , x_msg_count out nocopy NUMBER
213: , x_msg_data out nocopy VARCHAR2
214: , p_disposition_id NUMBER
215: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
219: );

Line 216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

212: , x_msg_count out nocopy NUMBER
213: , x_msg_data out nocopy VARCHAR2
214: , p_disposition_id NUMBER
215: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
219: );
220: end ahl_prd_disp_util_pvt_w;

Line 217: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

213: , x_msg_data out nocopy VARCHAR2
214: , p_disposition_id NUMBER
215: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
219: );
220: end ahl_prd_disp_util_pvt_w;

Line 218: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

214: , p_disposition_id NUMBER
215: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
219: );
220: end ahl_prd_disp_util_pvt_w;