DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT_W dependencies on JTF_DATE_TABLE

Line 9: , a6 JTF_DATE_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE

Line 12: , a9 JTF_DATE_TABLE

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

Line 13: , a10 JTF_DATE_TABLE

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

Line 39: , a6 out nocopy JTF_DATE_TABLE

35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
37: , a4 out nocopy JTF_VARCHAR2_TABLE_100
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE

Line 42: , a9 out nocopy JTF_DATE_TABLE

38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_VARCHAR2_TABLE_200
46: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 43: , a10 out nocopy JTF_DATE_TABLE

39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_VARCHAR2_TABLE_200
46: , a13 out nocopy JTF_VARCHAR2_TABLE_200
47: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a5 JTF_DATE_TABLE

65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_VARCHAR2_TABLE_200
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_DATE_TABLE
71: , a7 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 70: , a6 JTF_DATE_TABLE

66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_VARCHAR2_TABLE_200
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_DATE_TABLE
71: , a7 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE

Line 78: , a5 out nocopy JTF_DATE_TABLE

74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_VARCHAR2_TABLE_200
78: , a5 out nocopy JTF_DATE_TABLE
79: , a6 out nocopy JTF_DATE_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: );
82:

Line 79: , a6 out nocopy JTF_DATE_TABLE

75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_VARCHAR2_TABLE_200
78: , a5 out nocopy JTF_DATE_TABLE
79: , a6 out nocopy JTF_DATE_TABLE
80: , a7 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE

Line 89: , a6 JTF_DATE_TABLE

85: , a2 JTF_NUMBER_TABLE
86: , a3 JTF_VARCHAR2_TABLE_100
87: , a4 JTF_VARCHAR2_TABLE_400
88: , a5 JTF_VARCHAR2_TABLE_100
89: , a6 JTF_DATE_TABLE
90: , a7 JTF_DATE_TABLE
91: );
92: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE

Line 90: , a7 JTF_DATE_TABLE

86: , a3 JTF_VARCHAR2_TABLE_100
87: , a4 JTF_VARCHAR2_TABLE_400
88: , a5 JTF_VARCHAR2_TABLE_100
89: , a6 JTF_DATE_TABLE
90: , a7 JTF_DATE_TABLE
91: );
92: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE

Line 98: , a6 out nocopy JTF_DATE_TABLE

94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_400
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: );
101:
102: procedure create_comp_plan(p_api_version NUMBER

Line 99: , a7 out nocopy JTF_DATE_TABLE

95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_400
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: );
101:
102: procedure create_comp_plan(p_api_version NUMBER
103: , p_init_msg_list VARCHAR2

Line 229: , p9_a6 out nocopy JTF_DATE_TABLE

225: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
227: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a6 out nocopy JTF_DATE_TABLE
230: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a9 out nocopy JTF_DATE_TABLE
233: , p9_a10 out nocopy JTF_DATE_TABLE

Line 232: , p9_a9 out nocopy JTF_DATE_TABLE

228: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a6 out nocopy JTF_DATE_TABLE
230: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a9 out nocopy JTF_DATE_TABLE
233: , p9_a10 out nocopy JTF_DATE_TABLE
234: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
235: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
236: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 233: , p9_a10 out nocopy JTF_DATE_TABLE

229: , p9_a6 out nocopy JTF_DATE_TABLE
230: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a9 out nocopy JTF_DATE_TABLE
233: , p9_a10 out nocopy JTF_DATE_TABLE
234: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
235: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
236: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
237: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 268: , p5_a6 out nocopy JTF_DATE_TABLE

264: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
266: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
268: , p5_a6 out nocopy JTF_DATE_TABLE
269: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a9 out nocopy JTF_DATE_TABLE
272: , p5_a10 out nocopy JTF_DATE_TABLE

Line 271: , p5_a9 out nocopy JTF_DATE_TABLE

267: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
268: , p5_a6 out nocopy JTF_DATE_TABLE
269: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a9 out nocopy JTF_DATE_TABLE
272: , p5_a10 out nocopy JTF_DATE_TABLE
273: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
275: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 272: , p5_a10 out nocopy JTF_DATE_TABLE

268: , p5_a6 out nocopy JTF_DATE_TABLE
269: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a9 out nocopy JTF_DATE_TABLE
272: , p5_a10 out nocopy JTF_DATE_TABLE
273: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
275: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200
276: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 305: , p5_a5 out nocopy JTF_DATE_TABLE

301: , p5_a1 out nocopy JTF_NUMBER_TABLE
302: , p5_a2 out nocopy JTF_NUMBER_TABLE
303: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
305: , p5_a5 out nocopy JTF_DATE_TABLE
306: , p5_a6 out nocopy JTF_DATE_TABLE
307: , p5_a7 out nocopy JTF_NUMBER_TABLE
308: , x_return_status out nocopy VARCHAR2
309: , x_msg_count out nocopy NUMBER

Line 306: , p5_a6 out nocopy JTF_DATE_TABLE

302: , p5_a2 out nocopy JTF_NUMBER_TABLE
303: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
305: , p5_a5 out nocopy JTF_DATE_TABLE
306: , p5_a6 out nocopy JTF_DATE_TABLE
307: , p5_a7 out nocopy JTF_NUMBER_TABLE
308: , x_return_status out nocopy VARCHAR2
309: , x_msg_count out nocopy NUMBER
310: , x_msg_data out nocopy VARCHAR2

Line 359: , p4_a6 out nocopy JTF_DATE_TABLE

355: , p4_a2 out nocopy JTF_NUMBER_TABLE
356: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
357: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
358: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
359: , p4_a6 out nocopy JTF_DATE_TABLE
360: , p4_a7 out nocopy JTF_DATE_TABLE
361: );
362: end cn_comp_plan_pvt_w;

Line 360: , p4_a7 out nocopy JTF_DATE_TABLE

356: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
357: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
358: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
359: , p4_a6 out nocopy JTF_DATE_TABLE
360: , p4_a7 out nocopy JTF_DATE_TABLE
361: );
362: end cn_comp_plan_pvt_w;