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.CN_GET_SRP_DATA_PVT_W dependencies on JTF_DATE_TABLE

Line 16: , a3 JTF_DATE_TABLE

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 17: , a4 JTF_DATE_TABLE

13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300

Line 59: , a3 out nocopy JTF_DATE_TABLE

55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a4 out nocopy JTF_DATE_TABLE

56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 76: a3 := JTF_DATE_TABLE();

72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_400();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();

Line 77: a4 := JTF_DATE_TABLE();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_400();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_VARCHAR2_TABLE_300();

Line 90: a3 := JTF_DATE_TABLE();

86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_DATE_TABLE();
91: a4 := JTF_DATE_TABLE();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_VARCHAR2_TABLE_100();

Line 91: a4 := JTF_DATE_TABLE();

87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_DATE_TABLE();
91: a4 := JTF_DATE_TABLE();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_VARCHAR2_TABLE_100();
95: a8 := JTF_VARCHAR2_TABLE_300();

Line 143: , p0_a3 out nocopy JTF_DATE_TABLE

139:
140: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , p0_a4 out nocopy JTF_DATE_TABLE

140: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 195: , p10_a3 out nocopy JTF_DATE_TABLE

191: , x_total_rows out nocopy NUMBER
192: , p10_a0 out nocopy JTF_NUMBER_TABLE
193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 196: , p10_a4 out nocopy JTF_DATE_TABLE

192: , p10_a0 out nocopy JTF_NUMBER_TABLE
193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 270: , p1_a3 out nocopy JTF_DATE_TABLE

266: procedure get_srp_data(p_srp_id NUMBER
267: , p1_a0 out nocopy JTF_NUMBER_TABLE
268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , p1_a4 out nocopy JTF_DATE_TABLE

267: , p1_a0 out nocopy JTF_NUMBER_TABLE
268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 318: , p3_a3 out nocopy JTF_DATE_TABLE

314: , p_comp_group_id NUMBER
315: , p3_a0 out nocopy JTF_NUMBER_TABLE
316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p3_a4 out nocopy JTF_DATE_TABLE

315: , p3_a0 out nocopy JTF_NUMBER_TABLE
316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300