APPS.AHL_LTP_RESRC_LEVL_PUB_W dependencies on JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

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
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_NUMBER_TABLE

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
12: , a9 JTF_VARCHAR2_TABLE_300

Line 9: , a6 JTF_NUMBER_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
12: , a9 JTF_VARCHAR2_TABLE_300
13: );

Line 17: , a3 out nocopy JTF_NUMBER_TABLE

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
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a5 out nocopy JTF_NUMBER_TABLE

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
23: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 20: , a6 out nocopy JTF_NUMBER_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
23: , a9 out nocopy JTF_VARCHAR2_TABLE_300
24: );

Line 26: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE

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
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_100

Line 27: , a1 JTF_NUMBER_TABLE

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
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

Line 32: , a6 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: );
36: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 33: , a7 JTF_NUMBER_TABLE

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: );
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

Line 34: , a8 JTF_NUMBER_TABLE

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: );
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

Line 36: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE

32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
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

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: , a7 JTF_NUMBER_TABLE
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

Line 42: , a6 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: );
46:

Line 43: , a7 out nocopy JTF_NUMBER_TABLE

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: );
46:
47: procedure derive_resource_capacity(p_api_version NUMBER

Line 44: , a8 out nocopy JTF_NUMBER_TABLE

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: );
46:
47: procedure derive_resource_capacity(p_api_version NUMBER
48: , p_init_msg_list VARCHAR2

Line 69: , p6_a3 out nocopy JTF_NUMBER_TABLE

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
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

Line 71: , p6_a5 out nocopy JTF_NUMBER_TABLE

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
75: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 72: , p6_a6 out nocopy JTF_NUMBER_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
75: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
76: , x_return_status out nocopy VARCHAR2

Line 99: , p6_a0 out nocopy JTF_NUMBER_TABLE

95: , p5_a10 NUMBER
96: , p5_a11 NUMBER
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

Line 100: , p6_a1 out nocopy JTF_NUMBER_TABLE

96: , p5_a11 NUMBER
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

Line 105: , p6_a6 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
109: , x_msg_count out nocopy NUMBER

Line 106: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2

Line 107: , p6_a8 out nocopy JTF_NUMBER_TABLE

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
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: );