APPS.CN_COMP_PLAN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpns.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpns.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
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

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
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_DATE_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
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_DATE_TABLE
12: , a9 JTF_DATE_TABLE

Line 10: , a7 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_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 33: , a1 out nocopy JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: , a2 out nocopy JTF_VARCHAR2_TABLE_100

30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_DATE_TABLE

Line 36: , a4 out nocopy JTF_VARCHAR2_TABLE_100

32: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_DATE_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_DATE_TABLE

Line 37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_DATE_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_DATE_TABLE
41: , a9 out nocopy JTF_DATE_TABLE

Line 39: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 42: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 65: , a3 JTF_VARCHAR2_TABLE_100

61:
62: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_DATE_TABLE
68: , a6 JTF_DATE_TABLE
69: , a7 JTF_NUMBER_TABLE

Line 74: , a3 out nocopy JTF_VARCHAR2_TABLE_100

70: );
71: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_VARCHAR2_TABLE_200
76: , a5 out nocopy JTF_DATE_TABLE
77: , a6 out nocopy JTF_DATE_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE

Line 84: , a3 JTF_VARCHAR2_TABLE_100

80:
81: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_400
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_DATE_TABLE
88: , a7 JTF_DATE_TABLE

Line 86: , a5 JTF_VARCHAR2_TABLE_100

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

Line 93: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 95: , a5 out nocopy JTF_VARCHAR2_TABLE_100

91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_400
95: , a5 out nocopy JTF_VARCHAR2_TABLE_100
96: , a6 out nocopy JTF_DATE_TABLE
97: , a7 out nocopy JTF_DATE_TABLE
98: );
99:

Line 219: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

215: , p_search_name VARCHAR2
216: , p_search_date DATE
217: , p_search_status VARCHAR2
218: , p9_a0 out nocopy JTF_NUMBER_TABLE
219: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 220: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

216: , p_search_date DATE
217: , p_search_status VARCHAR2
218: , p9_a0 out nocopy JTF_NUMBER_TABLE
219: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a6 out nocopy JTF_DATE_TABLE

Line 222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

218: , p9_a0 out nocopy JTF_NUMBER_TABLE
219: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a6 out nocopy JTF_DATE_TABLE
225: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a8 out nocopy JTF_DATE_TABLE

Line 223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

219: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a6 out nocopy JTF_DATE_TABLE
225: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a8 out nocopy JTF_DATE_TABLE
227: , p9_a9 out nocopy JTF_DATE_TABLE

Line 225: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100

221: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
222: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a6 out nocopy JTF_DATE_TABLE
225: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a8 out nocopy JTF_DATE_TABLE
227: , p9_a9 out nocopy JTF_DATE_TABLE
228: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 228: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

224: , p9_a6 out nocopy JTF_DATE_TABLE
225: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a8 out nocopy JTF_DATE_TABLE
227: , p9_a9 out nocopy JTF_DATE_TABLE
228: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
230: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
231: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
232: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 257: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

253: , p_commit VARCHAR2
254: , p_validation_level NUMBER
255: , p_comp_plan_id NUMBER
256: , p5_a0 out nocopy JTF_NUMBER_TABLE
257: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

254: , p_validation_level NUMBER
255: , p_comp_plan_id NUMBER
256: , p5_a0 out nocopy JTF_NUMBER_TABLE
257: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a6 out nocopy JTF_DATE_TABLE

Line 260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

256: , p5_a0 out nocopy JTF_NUMBER_TABLE
257: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a6 out nocopy JTF_DATE_TABLE
263: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
264: , p5_a8 out nocopy JTF_DATE_TABLE

Line 261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

257: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a6 out nocopy JTF_DATE_TABLE
263: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
264: , p5_a8 out nocopy JTF_DATE_TABLE
265: , p5_a9 out nocopy JTF_DATE_TABLE

Line 263: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100

259: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
260: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a6 out nocopy JTF_DATE_TABLE
263: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
264: , p5_a8 out nocopy JTF_DATE_TABLE
265: , p5_a9 out nocopy JTF_DATE_TABLE
266: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 266: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

262: , p5_a6 out nocopy JTF_DATE_TABLE
263: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
264: , p5_a8 out nocopy JTF_DATE_TABLE
265: , p5_a9 out nocopy JTF_DATE_TABLE
266: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200
268: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
269: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200
270: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 296: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

292: , p_comp_plan_id NUMBER
293: , p5_a0 out nocopy JTF_NUMBER_TABLE
294: , p5_a1 out nocopy JTF_NUMBER_TABLE
295: , p5_a2 out nocopy JTF_NUMBER_TABLE
296: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
298: , p5_a5 out nocopy JTF_DATE_TABLE
299: , p5_a6 out nocopy JTF_DATE_TABLE
300: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 348: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

344: , x_total_rows out nocopy NUMBER
345: , p4_a0 out nocopy JTF_NUMBER_TABLE
346: , p4_a1 out nocopy JTF_NUMBER_TABLE
347: , p4_a2 out nocopy JTF_NUMBER_TABLE
348: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
349: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
350: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
351: , p4_a6 out nocopy JTF_DATE_TABLE
352: , p4_a7 out nocopy JTF_DATE_TABLE

Line 350: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

346: , p4_a1 out nocopy JTF_NUMBER_TABLE
347: , p4_a2 out nocopy JTF_NUMBER_TABLE
348: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
349: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
350: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
351: , p4_a6 out nocopy JTF_DATE_TABLE
352: , p4_a7 out nocopy JTF_DATE_TABLE
353: );
354: end cn_comp_plan_pvt_w;