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 AUTHID CURRENT_USER as
2: /* $Header: cnwcmpns.pls 120.2.12010000.2 2009/08/04 17:21:46 rnagaraj ship $ */
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 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_VARCHAR2_TABLE_200
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

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

Line 60: , a27 out nocopy JTF_NUMBER_TABLE

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

Line 61: , a28 out nocopy JTF_NUMBER_TABLE

57: , a24 out nocopy JTF_VARCHAR2_TABLE_200
58: , a25 out nocopy JTF_VARCHAR2_TABLE_200
59: , a26 out nocopy JTF_VARCHAR2_TABLE_200
60: , a27 out nocopy JTF_NUMBER_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE

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

60: , a27 out nocopy JTF_NUMBER_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_VARCHAR2_TABLE_200

Line 65: , a1 JTF_NUMBER_TABLE

61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_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

Line 66: , a2 JTF_NUMBER_TABLE

62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_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

Line 71: , a7 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
75: , a2 out nocopy JTF_NUMBER_TABLE

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

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
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 74: , a1 out nocopy JTF_NUMBER_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
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

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

Line 80: , a7 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
84: , a1 JTF_NUMBER_TABLE

Line 83: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_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
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_NUMBER_TABLE
86: , a3 JTF_VARCHAR2_TABLE_100
87: , a4 JTF_VARCHAR2_TABLE_400

Line 84: , a1 JTF_NUMBER_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
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_NUMBER_TABLE
86: , a3 JTF_VARCHAR2_TABLE_100
87: , a4 JTF_VARCHAR2_TABLE_400
88: , a5 JTF_VARCHAR2_TABLE_100

Line 85: , a2 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
84: , a1 JTF_NUMBER_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

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

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
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 93: , a1 out nocopy JTF_NUMBER_TABLE

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
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_400
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 223: , p9_a0 out nocopy JTF_NUMBER_TABLE

219: , p_fetch_size NUMBER
220: , p_search_name VARCHAR2
221: , p_search_date DATE
222: , p_search_status VARCHAR2
223: , p9_a0 out nocopy JTF_NUMBER_TABLE
224: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 250: , p9_a27 out nocopy JTF_NUMBER_TABLE

246: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
247: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
248: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
249: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a27 out nocopy JTF_NUMBER_TABLE
251: , p9_a28 out nocopy JTF_NUMBER_TABLE
252: , x_total_record out nocopy NUMBER
253: , x_return_status out nocopy VARCHAR2
254: , x_msg_count out nocopy NUMBER

Line 251: , p9_a28 out nocopy JTF_NUMBER_TABLE

247: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
248: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
249: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a27 out nocopy JTF_NUMBER_TABLE
251: , p9_a28 out nocopy JTF_NUMBER_TABLE
252: , x_total_record out nocopy NUMBER
253: , x_return_status out nocopy VARCHAR2
254: , x_msg_count out nocopy NUMBER
255: , x_msg_data out nocopy VARCHAR2

Line 262: , p5_a0 out nocopy JTF_NUMBER_TABLE

258: , p_init_msg_list VARCHAR2
259: , p_commit VARCHAR2
260: , p_validation_level NUMBER
261: , p_comp_plan_id NUMBER
262: , p5_a0 out nocopy JTF_NUMBER_TABLE
263: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 289: , p5_a27 out nocopy JTF_NUMBER_TABLE

285: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
286: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
287: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
288: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
289: , p5_a27 out nocopy JTF_NUMBER_TABLE
290: , p5_a28 out nocopy JTF_NUMBER_TABLE
291: , x_return_status out nocopy VARCHAR2
292: , x_msg_count out nocopy NUMBER
293: , x_msg_data out nocopy VARCHAR2

Line 290: , p5_a28 out nocopy JTF_NUMBER_TABLE

286: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
287: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
288: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
289: , p5_a27 out nocopy JTF_NUMBER_TABLE
290: , p5_a28 out nocopy JTF_NUMBER_TABLE
291: , x_return_status out nocopy VARCHAR2
292: , x_msg_count out nocopy NUMBER
293: , x_msg_data out nocopy VARCHAR2
294: );

Line 300: , p5_a0 out nocopy JTF_NUMBER_TABLE

296: , p_init_msg_list VARCHAR2
297: , p_commit VARCHAR2
298: , p_validation_level NUMBER
299: , p_comp_plan_id NUMBER
300: , p5_a0 out nocopy JTF_NUMBER_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

Line 301: , p5_a1 out nocopy JTF_NUMBER_TABLE

297: , p_commit VARCHAR2
298: , p_validation_level NUMBER
299: , p_comp_plan_id NUMBER
300: , p5_a0 out nocopy JTF_NUMBER_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

Line 302: , p5_a2 out nocopy JTF_NUMBER_TABLE

298: , p_validation_level NUMBER
299: , p_comp_plan_id NUMBER
300: , p5_a0 out nocopy JTF_NUMBER_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

Line 307: , p5_a7 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
311: );

Line 353: , p4_a0 out nocopy JTF_NUMBER_TABLE

349: procedure get_assigned_salesreps(p_comp_plan_id NUMBER
350: , p_range_low NUMBER
351: , p_range_high NUMBER
352: , x_total_rows out nocopy NUMBER
353: , p4_a0 out nocopy JTF_NUMBER_TABLE
354: , p4_a1 out nocopy JTF_NUMBER_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

Line 354: , p4_a1 out nocopy JTF_NUMBER_TABLE

350: , p_range_low NUMBER
351: , p_range_high NUMBER
352: , x_total_rows out nocopy NUMBER
353: , p4_a0 out nocopy JTF_NUMBER_TABLE
354: , p4_a1 out nocopy JTF_NUMBER_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

Line 355: , p4_a2 out nocopy JTF_NUMBER_TABLE

351: , p_range_high NUMBER
352: , x_total_rows out nocopy NUMBER
353: , p4_a0 out nocopy JTF_NUMBER_TABLE
354: , p4_a1 out nocopy JTF_NUMBER_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