eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PERD_STATUS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_perd_status_pvt_w as
2: /* $Header: OKLEPSMS.pls 120.1 2005/07/11 14:19:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_perd_status_pvt_w as
2: /* $Header: OKLEPSMS.pls 120.1 2005/07/11 14:19:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE

Line 17: , a14 JTF_NUMBER_TABLE

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

Line 18: , a15 JTF_NUMBER_TABLE

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

Line 27: , a24 JTF_NUMBER_TABLE

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

Line 30: procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_DATE_TABLE
34: , a4 out nocopy JTF_NUMBER_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 okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_DATE_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: , a4 out nocopy JTF_NUMBER_TABLE

30: procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_DATE_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_DATE_TABLE
37: , a7 out nocopy JTF_DATE_TABLE
38: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 40: , a10 out nocopy JTF_NUMBER_TABLE

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

Line 41: , a11 out nocopy JTF_NUMBER_TABLE

37: , a7 out nocopy JTF_DATE_TABLE
38: , a8 out nocopy JTF_VARCHAR2_TABLE_100
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_NUMBER_TABLE
41: , a11 out nocopy JTF_NUMBER_TABLE
42: , a12 out nocopy JTF_VARCHAR2_TABLE_100
43: , a13 out nocopy JTF_DATE_TABLE
44: , a14 out nocopy JTF_NUMBER_TABLE
45: , a15 out nocopy JTF_NUMBER_TABLE

Line 44: , a14 out nocopy JTF_NUMBER_TABLE

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

Line 45: , a15 out nocopy JTF_NUMBER_TABLE

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

Line 54: , a24 out nocopy JTF_NUMBER_TABLE

50: , a20 out nocopy JTF_VARCHAR2_TABLE_200
51: , a21 out nocopy JTF_VARCHAR2_TABLE_200
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_DATE_TABLE
54: , a24 out nocopy JTF_NUMBER_TABLE
55: , a25 out nocopy JTF_VARCHAR2_TABLE_100
56: );
57:
58: procedure search_period_status(p_api_version NUMBER

Line 63: , p6_a0 out nocopy JTF_NUMBER_TABLE

59: , p_init_msg_list VARCHAR2
60: , x_return_status out nocopy VARCHAR2
61: , x_msg_count out nocopy NUMBER
62: , x_msg_data out nocopy VARCHAR2
63: , p6_a0 out nocopy JTF_NUMBER_TABLE
64: , p6_a1 out nocopy JTF_NUMBER_TABLE
65: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a3 out nocopy JTF_DATE_TABLE
67: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 64: , p6_a1 out nocopy JTF_NUMBER_TABLE

60: , x_return_status out nocopy VARCHAR2
61: , x_msg_count out nocopy NUMBER
62: , x_msg_data out nocopy VARCHAR2
63: , p6_a0 out nocopy JTF_NUMBER_TABLE
64: , p6_a1 out nocopy JTF_NUMBER_TABLE
65: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a3 out nocopy JTF_DATE_TABLE
67: , p6_a4 out nocopy JTF_NUMBER_TABLE
68: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , p6_a4 out nocopy JTF_NUMBER_TABLE

63: , p6_a0 out nocopy JTF_NUMBER_TABLE
64: , p6_a1 out nocopy JTF_NUMBER_TABLE
65: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a3 out nocopy JTF_DATE_TABLE
67: , p6_a4 out nocopy JTF_NUMBER_TABLE
68: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a6 out nocopy JTF_DATE_TABLE
70: , p6_a7 out nocopy JTF_DATE_TABLE
71: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: , p6_a9 out nocopy JTF_NUMBER_TABLE

68: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a6 out nocopy JTF_DATE_TABLE
70: , p6_a7 out nocopy JTF_DATE_TABLE
71: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a9 out nocopy JTF_NUMBER_TABLE
73: , p6_a10 out nocopy JTF_NUMBER_TABLE
74: , p6_a11 out nocopy JTF_NUMBER_TABLE
75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a13 out nocopy JTF_DATE_TABLE

Line 73: , p6_a10 out nocopy JTF_NUMBER_TABLE

69: , p6_a6 out nocopy JTF_DATE_TABLE
70: , p6_a7 out nocopy JTF_DATE_TABLE
71: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a9 out nocopy JTF_NUMBER_TABLE
73: , p6_a10 out nocopy JTF_NUMBER_TABLE
74: , p6_a11 out nocopy JTF_NUMBER_TABLE
75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a13 out nocopy JTF_DATE_TABLE
77: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 74: , p6_a11 out nocopy JTF_NUMBER_TABLE

70: , p6_a7 out nocopy JTF_DATE_TABLE
71: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a9 out nocopy JTF_NUMBER_TABLE
73: , p6_a10 out nocopy JTF_NUMBER_TABLE
74: , p6_a11 out nocopy JTF_NUMBER_TABLE
75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a13 out nocopy JTF_DATE_TABLE
77: , p6_a14 out nocopy JTF_NUMBER_TABLE
78: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 77: , p6_a14 out nocopy JTF_NUMBER_TABLE

73: , p6_a10 out nocopy JTF_NUMBER_TABLE
74: , p6_a11 out nocopy JTF_NUMBER_TABLE
75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a13 out nocopy JTF_DATE_TABLE
77: , p6_a14 out nocopy JTF_NUMBER_TABLE
78: , p6_a15 out nocopy JTF_NUMBER_TABLE
79: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
80: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
81: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 78: , p6_a15 out nocopy JTF_NUMBER_TABLE

74: , p6_a11 out nocopy JTF_NUMBER_TABLE
75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a13 out nocopy JTF_DATE_TABLE
77: , p6_a14 out nocopy JTF_NUMBER_TABLE
78: , p6_a15 out nocopy JTF_NUMBER_TABLE
79: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
80: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
81: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
82: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 87: , p6_a24 out nocopy JTF_NUMBER_TABLE

83: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
84: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
85: , p6_a22 out nocopy JTF_DATE_TABLE
86: , p6_a23 out nocopy JTF_DATE_TABLE
87: , p6_a24 out nocopy JTF_NUMBER_TABLE
88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 121: , p5_a0 JTF_NUMBER_TABLE

117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_VARCHAR2_TABLE_100
124: , p5_a3 JTF_DATE_TABLE
125: , p5_a4 JTF_NUMBER_TABLE

Line 122: , p5_a1 JTF_NUMBER_TABLE

118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_VARCHAR2_TABLE_100
124: , p5_a3 JTF_DATE_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 125: , p5_a4 JTF_NUMBER_TABLE

121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_VARCHAR2_TABLE_100
124: , p5_a3 JTF_DATE_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_DATE_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 130: , p5_a9 JTF_NUMBER_TABLE

126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_DATE_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_VARCHAR2_TABLE_100
130: , p5_a9 JTF_NUMBER_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p5_a11 JTF_NUMBER_TABLE
133: , p5_a12 JTF_VARCHAR2_TABLE_100
134: , p5_a13 JTF_DATE_TABLE

Line 131: , p5_a10 JTF_NUMBER_TABLE

127: , p5_a6 JTF_DATE_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_VARCHAR2_TABLE_100
130: , p5_a9 JTF_NUMBER_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p5_a11 JTF_NUMBER_TABLE
133: , p5_a12 JTF_VARCHAR2_TABLE_100
134: , p5_a13 JTF_DATE_TABLE
135: , p5_a14 JTF_NUMBER_TABLE

Line 132: , p5_a11 JTF_NUMBER_TABLE

128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_VARCHAR2_TABLE_100
130: , p5_a9 JTF_NUMBER_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p5_a11 JTF_NUMBER_TABLE
133: , p5_a12 JTF_VARCHAR2_TABLE_100
134: , p5_a13 JTF_DATE_TABLE
135: , p5_a14 JTF_NUMBER_TABLE
136: , p5_a15 JTF_NUMBER_TABLE

Line 135: , p5_a14 JTF_NUMBER_TABLE

131: , p5_a10 JTF_NUMBER_TABLE
132: , p5_a11 JTF_NUMBER_TABLE
133: , p5_a12 JTF_VARCHAR2_TABLE_100
134: , p5_a13 JTF_DATE_TABLE
135: , p5_a14 JTF_NUMBER_TABLE
136: , p5_a15 JTF_NUMBER_TABLE
137: , p5_a16 JTF_VARCHAR2_TABLE_200
138: , p5_a17 JTF_VARCHAR2_TABLE_200
139: , p5_a18 JTF_VARCHAR2_TABLE_200

Line 136: , p5_a15 JTF_NUMBER_TABLE

132: , p5_a11 JTF_NUMBER_TABLE
133: , p5_a12 JTF_VARCHAR2_TABLE_100
134: , p5_a13 JTF_DATE_TABLE
135: , p5_a14 JTF_NUMBER_TABLE
136: , p5_a15 JTF_NUMBER_TABLE
137: , p5_a16 JTF_VARCHAR2_TABLE_200
138: , p5_a17 JTF_VARCHAR2_TABLE_200
139: , p5_a18 JTF_VARCHAR2_TABLE_200
140: , p5_a19 JTF_VARCHAR2_TABLE_200

Line 145: , p5_a24 JTF_NUMBER_TABLE

141: , p5_a20 JTF_VARCHAR2_TABLE_200
142: , p5_a21 JTF_VARCHAR2_TABLE_200
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_DATE_TABLE
145: , p5_a24 JTF_NUMBER_TABLE
146: , p5_a25 JTF_VARCHAR2_TABLE_100
147: );
148: procedure update_perd_row(p_api_version NUMBER
149: , p_init_msg_list VARCHAR2