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_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
9: , a6 JTF_DATE_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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

Line 11: , a8 JTF_VARCHAR2_TABLE_100

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
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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
19: , a16 JTF_VARCHAR2_TABLE_200

Line 28: , a25 JTF_VARCHAR2_TABLE_100

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
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
36: , a6 out nocopy JTF_DATE_TABLE

Line 35: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
39: , a9 out nocopy JTF_NUMBER_TABLE

Line 38: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 42: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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
46: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 55: , a25 out nocopy JTF_VARCHAR2_TABLE_100

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
59: , p_init_msg_list VARCHAR2

Line 65: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
69: , p6_a6 out nocopy JTF_DATE_TABLE

Line 68: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
72: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 71: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 75: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
79: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

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
92: , p5_a3 DATE := fnd_api.g_miss_date

Line 123: , p5_a2 JTF_VARCHAR2_TABLE_100

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
127: , p5_a6 JTF_DATE_TABLE

Line 126: , p5_a5 JTF_VARCHAR2_TABLE_100

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
130: , p5_a9 JTF_NUMBER_TABLE

Line 129: , p5_a8 JTF_VARCHAR2_TABLE_100

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

Line 133: , p5_a12 JTF_VARCHAR2_TABLE_100

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
137: , p5_a16 JTF_VARCHAR2_TABLE_200

Line 146: , p5_a25 JTF_VARCHAR2_TABLE_100

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
150: , x_return_status out nocopy VARCHAR2