APPS.AHL_LTP_RESRC_LEVL_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100

1: package ahl_ltp_resrc_levl_pub_w as
2: /* $Header: AHLWRLGS.pls 120.1 2006/05/04 07:38 anraj noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: );
14: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: );
14: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
15: , a1 out nocopy JTF_DATE_TABLE

Line 14: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: );
14: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

14: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 21: , a7 out nocopy JTF_VARCHAR2_TABLE_100

17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_300
24: );
25:

Line 22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_300
24: );
25:
26: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE

Line 28: , a2 JTF_VARCHAR2_TABLE_100

24: );
25:
26: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_100
31: , a5 JTF_VARCHAR2_TABLE_100
32: , a6 JTF_NUMBER_TABLE

Line 29: , a3 JTF_VARCHAR2_TABLE_100

25:
26: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_100
31: , a5 JTF_VARCHAR2_TABLE_100
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE

Line 30: , a4 JTF_VARCHAR2_TABLE_100

26: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_100
31: , a5 JTF_VARCHAR2_TABLE_100
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE

Line 31: , a5 JTF_VARCHAR2_TABLE_100

27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_100
31: , a5 JTF_VARCHAR2_TABLE_100
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: );

Line 38: , a2 out nocopy JTF_VARCHAR2_TABLE_100

34: , a8 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE

Line 39: , a3 out nocopy JTF_VARCHAR2_TABLE_100

35: );
36: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE

Line 40: , a4 out nocopy JTF_VARCHAR2_TABLE_100

36: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE

Line 41: , a5 out nocopy JTF_VARCHAR2_TABLE_100

37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: );

Line 66: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

62: , p5_a10 NUMBER
63: , p5_a11 NUMBER
64: , p5_a12 VARCHAR2
65: , p5_a13 VARCHAR2
66: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
67: , p6_a1 out nocopy JTF_DATE_TABLE
68: , p6_a2 out nocopy JTF_DATE_TABLE
69: , p6_a3 out nocopy JTF_NUMBER_TABLE
70: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

66: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
67: , p6_a1 out nocopy JTF_DATE_TABLE
68: , p6_a2 out nocopy JTF_DATE_TABLE
69: , p6_a3 out nocopy JTF_NUMBER_TABLE
70: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , p6_a5 out nocopy JTF_NUMBER_TABLE
72: , p6_a6 out nocopy JTF_NUMBER_TABLE
73: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

69: , p6_a3 out nocopy JTF_NUMBER_TABLE
70: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , p6_a5 out nocopy JTF_NUMBER_TABLE
72: , p6_a6 out nocopy JTF_NUMBER_TABLE
73: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
76: , x_return_status out nocopy VARCHAR2
77: , x_msg_count out nocopy NUMBER

Line 74: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

70: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , p6_a5 out nocopy JTF_NUMBER_TABLE
72: , p6_a6 out nocopy JTF_NUMBER_TABLE
73: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
76: , x_return_status out nocopy VARCHAR2
77: , x_msg_count out nocopy NUMBER
78: , x_msg_data out nocopy VARCHAR2

Line 101: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

97: , p5_a12 VARCHAR2
98: , p5_a13 VARCHAR2
99: , p6_a0 out nocopy JTF_NUMBER_TABLE
100: , p6_a1 out nocopy JTF_NUMBER_TABLE
101: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 102: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

98: , p5_a13 VARCHAR2
99: , p6_a0 out nocopy JTF_NUMBER_TABLE
100: , p6_a1 out nocopy JTF_NUMBER_TABLE
101: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a6 out nocopy JTF_NUMBER_TABLE
106: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 103: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

99: , p6_a0 out nocopy JTF_NUMBER_TABLE
100: , p6_a1 out nocopy JTF_NUMBER_TABLE
101: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a6 out nocopy JTF_NUMBER_TABLE
106: , p6_a7 out nocopy JTF_NUMBER_TABLE
107: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 104: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

100: , p6_a1 out nocopy JTF_NUMBER_TABLE
101: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a6 out nocopy JTF_NUMBER_TABLE
106: , p6_a7 out nocopy JTF_NUMBER_TABLE
107: , p6_a8 out nocopy JTF_NUMBER_TABLE
108: , x_return_status out nocopy VARCHAR2