APPS.CN_COMP_PLAN_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
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

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
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

Line 32: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_200
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

Line 58: , a26 out nocopy JTF_NUMBER_TABLE

54: , a22 out nocopy JTF_VARCHAR2_TABLE_200
55: , a23 out nocopy JTF_VARCHAR2_TABLE_200
56: , a24 out nocopy JTF_VARCHAR2_TABLE_200
57: , a25 out nocopy JTF_VARCHAR2_TABLE_200
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE

Line 59: , a27 out nocopy JTF_NUMBER_TABLE

55: , a23 out nocopy JTF_VARCHAR2_TABLE_200
56: , a24 out nocopy JTF_VARCHAR2_TABLE_200
57: , a25 out nocopy JTF_VARCHAR2_TABLE_200
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
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

Line 62: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE

58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
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

Line 63: , a1 JTF_NUMBER_TABLE

59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
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

Line 64: , a2 JTF_NUMBER_TABLE

60: );
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

Line 69: , a7 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
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

Line 71: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

67: , a5 JTF_DATE_TABLE
68: , a6 JTF_DATE_TABLE
69: , a7 JTF_NUMBER_TABLE
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

Line 72: , a1 out nocopy JTF_NUMBER_TABLE

68: , a6 JTF_DATE_TABLE
69: , a7 JTF_NUMBER_TABLE
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

Line 73: , a2 out nocopy JTF_NUMBER_TABLE

69: , a7 JTF_NUMBER_TABLE
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

Line 78: , a7 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
79: );
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

Line 81: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE

77: , a6 out nocopy JTF_DATE_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: );
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

Line 82: , a1 JTF_NUMBER_TABLE

78: , a7 out nocopy JTF_NUMBER_TABLE
79: );
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

Line 83: , a2 JTF_NUMBER_TABLE

79: );
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

Line 90: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 91: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 92: , a2 out nocopy JTF_NUMBER_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
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

Line 218: , p9_a0 out nocopy JTF_NUMBER_TABLE

214: , p_fetch_size NUMBER
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

Line 244: , p9_a26 out nocopy JTF_NUMBER_TABLE

240: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_200
241: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
242: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
243: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
244: , p9_a26 out nocopy JTF_NUMBER_TABLE
245: , p9_a27 out nocopy JTF_NUMBER_TABLE
246: , x_total_record out nocopy NUMBER
247: , x_return_status out nocopy VARCHAR2
248: , x_msg_count out nocopy NUMBER

Line 245: , p9_a27 out nocopy JTF_NUMBER_TABLE

241: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
242: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
243: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
244: , p9_a26 out nocopy JTF_NUMBER_TABLE
245: , p9_a27 out nocopy JTF_NUMBER_TABLE
246: , x_total_record out nocopy NUMBER
247: , x_return_status out nocopy VARCHAR2
248: , x_msg_count out nocopy NUMBER
249: , x_msg_data out nocopy VARCHAR2

Line 256: , p5_a0 out nocopy JTF_NUMBER_TABLE

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

Line 282: , p5_a26 out nocopy JTF_NUMBER_TABLE

278: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_200
279: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
280: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
281: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
282: , p5_a26 out nocopy JTF_NUMBER_TABLE
283: , p5_a27 out nocopy JTF_NUMBER_TABLE
284: , x_return_status out nocopy VARCHAR2
285: , x_msg_count out nocopy NUMBER
286: , x_msg_data out nocopy VARCHAR2

Line 283: , p5_a27 out nocopy JTF_NUMBER_TABLE

279: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
280: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
281: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
282: , p5_a26 out nocopy JTF_NUMBER_TABLE
283: , p5_a27 out nocopy JTF_NUMBER_TABLE
284: , x_return_status out nocopy VARCHAR2
285: , x_msg_count out nocopy NUMBER
286: , x_msg_data out nocopy VARCHAR2
287: );

Line 293: , p5_a0 out nocopy JTF_NUMBER_TABLE

289: , p_init_msg_list VARCHAR2
290: , p_commit VARCHAR2
291: , p_validation_level NUMBER
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

Line 294: , p5_a1 out nocopy JTF_NUMBER_TABLE

290: , p_commit VARCHAR2
291: , p_validation_level NUMBER
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

Line 295: , p5_a2 out nocopy JTF_NUMBER_TABLE

291: , p_validation_level NUMBER
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

Line 300: , p5_a7 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
301: , x_return_status out nocopy VARCHAR2
302: , x_msg_count out nocopy NUMBER
303: , x_msg_data out nocopy VARCHAR2
304: );

Line 345: , p4_a0 out nocopy JTF_NUMBER_TABLE

341: procedure get_assigned_salesreps(p_comp_plan_id NUMBER
342: , p_range_low NUMBER
343: , p_range_high NUMBER
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

Line 346: , p4_a1 out nocopy JTF_NUMBER_TABLE

342: , p_range_low NUMBER
343: , p_range_high NUMBER
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

Line 347: , p4_a2 out nocopy JTF_NUMBER_TABLE

343: , p_range_high NUMBER
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