APPS.OKL_LA_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_la_asset_pvt_w as
2: /* $Header: OKLELAAS.pls 120.5 2007/03/12 05:55:36 rviriyal ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_la_asset_pvt_w as
2: /* $Header: OKLELAAS.pls 120.5 2007/03/12 05:55:36 rviriyal ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 14: , a1 out nocopy JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE

Line 15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE

Line 20: , a7 out nocopy JTF_VARCHAR2_TABLE_100

16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE

Line 24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100

20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE

Line 26: , a2 JTF_VARCHAR2_TABLE_100

22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE

Line 27: , a3 JTF_VARCHAR2_TABLE_100

23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300

Line 40: , a16 JTF_VARCHAR2_TABLE_100

36: , a12 JTF_DATE_TABLE
37: , a13 JTF_DATE_TABLE
38: , a14 JTF_DATE_TABLE
39: , a15 JTF_DATE_TABLE
40: , a16 JTF_VARCHAR2_TABLE_100
41: , a17 JTF_VARCHAR2_TABLE_2000
42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100

Line 44: , a20 JTF_VARCHAR2_TABLE_100

40: , a16 JTF_VARCHAR2_TABLE_100
41: , a17 JTF_VARCHAR2_TABLE_2000
42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a21 JTF_VARCHAR2_TABLE_100

41: , a17 JTF_VARCHAR2_TABLE_2000
42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE

Line 46: , a22 JTF_VARCHAR2_TABLE_100

42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE

Line 50: , a2 out nocopy JTF_VARCHAR2_TABLE_100

46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 64: , a16 out nocopy JTF_VARCHAR2_TABLE_100

60: , a12 out nocopy JTF_DATE_TABLE
61: , a13 out nocopy JTF_DATE_TABLE
62: , a14 out nocopy JTF_DATE_TABLE
63: , a15 out nocopy JTF_DATE_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , a20 out nocopy JTF_VARCHAR2_TABLE_100

64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:

Line 69: , a21 out nocopy JTF_VARCHAR2_TABLE_100

65: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure generate_asset_summary(p_api_version NUMBER

Line 70: , a22 out nocopy JTF_VARCHAR2_TABLE_100

66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure generate_asset_summary(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2

Line 78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

74: , p_init_msg_list VARCHAR2
75: , x_return_status out nocopy VARCHAR2
76: , x_msg_count out nocopy NUMBER
77: , x_msg_data out nocopy VARCHAR2
78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

76: , x_msg_count out nocopy NUMBER
77: , x_msg_data out nocopy VARCHAR2
78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

77: , x_msg_data out nocopy VARCHAR2
78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 94: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

90: , p6_a12 out nocopy JTF_DATE_TABLE
91: , p6_a13 out nocopy JTF_DATE_TABLE
92: , p6_a14 out nocopy JTF_DATE_TABLE
93: , p6_a15 out nocopy JTF_DATE_TABLE
94: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

94: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a1 NUMBER := 0-1962.0724

Line 99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

95: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a1 NUMBER := 0-1962.0724
103: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a1 NUMBER := 0-1962.0724
103: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p5_a1 JTF_VARCHAR2_TABLE_100

138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE

Line 143: , p5_a2 JTF_VARCHAR2_TABLE_100

139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE

Line 148: , p5_a7 JTF_VARCHAR2_TABLE_100

144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_VARCHAR2_TABLE_100
150: );
151: end okl_la_asset_pvt_w;

Line 149: , p5_a8 JTF_VARCHAR2_TABLE_100

145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_VARCHAR2_TABLE_100
150: );
151: end okl_la_asset_pvt_w;