APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE

1: package cn_get_comm_summ_data_pvt_w as
2: /* $Header: cnwcomms.pls 120.4 2005/10/24 07:21 sjustina noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_DATE_TABLE
16: , a4 out nocopy JTF_DATE_TABLE

Line 17: , a5 out nocopy JTF_NUMBER_TABLE

13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_DATE_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:

Line 18: , a6 out nocopy JTF_NUMBER_TABLE

14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_DATE_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);

Line 19: , a7 out nocopy JTF_NUMBER_TABLE

15: , a3 out nocopy JTF_DATE_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);
23: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);

18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);
23: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
26: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);

Line 23: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);
23: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
26: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
27:

Line 28: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE

24:
25: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
26: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE

Line 30: , a2 JTF_NUMBER_TABLE

26: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE

Line 31: , a3 JTF_NUMBER_TABLE

27:
28: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE

Line 32: , a4 JTF_NUMBER_TABLE

28: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE

Line 33: , a5 JTF_NUMBER_TABLE

29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE

Line 34: , a6 JTF_NUMBER_TABLE

30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE

Line 35: , a7 JTF_NUMBER_TABLE

31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE

Line 36: , a8 JTF_NUMBER_TABLE

32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE
40: );

Line 37: , a9 JTF_NUMBER_TABLE

33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 38: , a10 JTF_NUMBER_TABLE

34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a11 JTF_NUMBER_TABLE

35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE

Line 41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_NUMBER_TABLE
39: , a11 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE

Line 43: , a2 out nocopy JTF_NUMBER_TABLE

39: , a11 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE

Line 44: , a3 out nocopy JTF_NUMBER_TABLE

40: );
41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE

Line 45: , a4 out nocopy JTF_NUMBER_TABLE

41: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE

Line 46: , a5 out nocopy JTF_NUMBER_TABLE

42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE

Line 47: , a6 out nocopy JTF_NUMBER_TABLE

43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE

Line 48: , a7 out nocopy JTF_NUMBER_TABLE

44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE

Line 49: , a8 out nocopy JTF_NUMBER_TABLE

45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: );

Line 50: , a9 out nocopy JTF_NUMBER_TABLE

46: , a5 out nocopy JTF_NUMBER_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: );
54:

Line 51: , a10 out nocopy JTF_NUMBER_TABLE

47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: );
54:
55: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400

Line 52: , a11 out nocopy JTF_NUMBER_TABLE

48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: );
54:
55: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
56: , a1 JTF_VARCHAR2_TABLE_100

Line 60: , a5 JTF_NUMBER_TABLE

56: , a1 JTF_VARCHAR2_TABLE_100
57: , a2 JTF_VARCHAR2_TABLE_100
58: , a3 JTF_VARCHAR2_TABLE_100
59: , a4 JTF_VARCHAR2_TABLE_100
60: , a5 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
63: , a1 out nocopy JTF_VARCHAR2_TABLE_100
64: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a5 out nocopy JTF_NUMBER_TABLE

63: , a1 out nocopy JTF_VARCHAR2_TABLE_100
64: , a2 out nocopy JTF_VARCHAR2_TABLE_100
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_100
67: , a5 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE

Line 70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE

66: , a4 out nocopy JTF_VARCHAR2_TABLE_100
67: , a5 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE

Line 71: , a1 JTF_NUMBER_TABLE

67: , a5 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: );

Line 73: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

69:
70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: );
76:
77: procedure get_salesrep_list(p_first NUMBER

Line 74: , a1 out nocopy JTF_NUMBER_TABLE

70: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: );
73: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: );
76:
77: procedure get_salesrep_list(p_first NUMBER
78: , p_last NUMBER

Line 83: , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE

79: , p_period_id NUMBER
80: , p_analyst_id NUMBER
81: , p_org_id NUMBER
82: , x_total_rows out nocopy NUMBER
83: , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE
84: );
85: procedure get_quota_summary(p_salesrep_id NUMBER
86: , p_period_id NUMBER
87: , p_credit_type_id NUMBER

Line 89: , p4_a0 out nocopy JTF_NUMBER_TABLE

85: procedure get_quota_summary(p_salesrep_id NUMBER
86: , p_period_id NUMBER
87: , p_credit_type_id NUMBER
88: , p_org_id NUMBER
89: , p4_a0 out nocopy JTF_NUMBER_TABLE
90: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , p4_a3 out nocopy JTF_DATE_TABLE
93: , p4_a4 out nocopy JTF_DATE_TABLE

Line 94: , p4_a5 out nocopy JTF_NUMBER_TABLE

90: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , p4_a3 out nocopy JTF_DATE_TABLE
93: , p4_a4 out nocopy JTF_DATE_TABLE
94: , p4_a5 out nocopy JTF_NUMBER_TABLE
95: , p4_a6 out nocopy JTF_NUMBER_TABLE
96: , p4_a7 out nocopy JTF_NUMBER_TABLE
97: );
98: procedure get_quota_manager_summary(p_period_id NUMBER

Line 95: , p4_a6 out nocopy JTF_NUMBER_TABLE

91: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , p4_a3 out nocopy JTF_DATE_TABLE
93: , p4_a4 out nocopy JTF_DATE_TABLE
94: , p4_a5 out nocopy JTF_NUMBER_TABLE
95: , p4_a6 out nocopy JTF_NUMBER_TABLE
96: , p4_a7 out nocopy JTF_NUMBER_TABLE
97: );
98: procedure get_quota_manager_summary(p_period_id NUMBER
99: , p_credit_type_id NUMBER

Line 96: , p4_a7 out nocopy JTF_NUMBER_TABLE

92: , p4_a3 out nocopy JTF_DATE_TABLE
93: , p4_a4 out nocopy JTF_DATE_TABLE
94: , p4_a5 out nocopy JTF_NUMBER_TABLE
95: , p4_a6 out nocopy JTF_NUMBER_TABLE
96: , p4_a7 out nocopy JTF_NUMBER_TABLE
97: );
98: procedure get_quota_manager_summary(p_period_id NUMBER
99: , p_credit_type_id NUMBER
100: , p_org_id NUMBER

Line 101: , p3_a0 out nocopy JTF_NUMBER_TABLE

97: );
98: procedure get_quota_manager_summary(p_period_id NUMBER
99: , p_credit_type_id NUMBER
100: , p_org_id NUMBER
101: , p3_a0 out nocopy JTF_NUMBER_TABLE
102: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , p3_a3 out nocopy JTF_DATE_TABLE
105: , p3_a4 out nocopy JTF_DATE_TABLE

Line 106: , p3_a5 out nocopy JTF_NUMBER_TABLE

102: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , p3_a3 out nocopy JTF_DATE_TABLE
105: , p3_a4 out nocopy JTF_DATE_TABLE
106: , p3_a5 out nocopy JTF_NUMBER_TABLE
107: , p3_a6 out nocopy JTF_NUMBER_TABLE
108: , p3_a7 out nocopy JTF_NUMBER_TABLE
109: );
110: procedure get_quota_analyst_summary(p_period_id NUMBER

Line 107: , p3_a6 out nocopy JTF_NUMBER_TABLE

103: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , p3_a3 out nocopy JTF_DATE_TABLE
105: , p3_a4 out nocopy JTF_DATE_TABLE
106: , p3_a5 out nocopy JTF_NUMBER_TABLE
107: , p3_a6 out nocopy JTF_NUMBER_TABLE
108: , p3_a7 out nocopy JTF_NUMBER_TABLE
109: );
110: procedure get_quota_analyst_summary(p_period_id NUMBER
111: , p_credit_type_id NUMBER

Line 108: , p3_a7 out nocopy JTF_NUMBER_TABLE

104: , p3_a3 out nocopy JTF_DATE_TABLE
105: , p3_a4 out nocopy JTF_DATE_TABLE
106: , p3_a5 out nocopy JTF_NUMBER_TABLE
107: , p3_a6 out nocopy JTF_NUMBER_TABLE
108: , p3_a7 out nocopy JTF_NUMBER_TABLE
109: );
110: procedure get_quota_analyst_summary(p_period_id NUMBER
111: , p_credit_type_id NUMBER
112: , p_org_id NUMBER

Line 114: , p4_a0 out nocopy JTF_NUMBER_TABLE

110: procedure get_quota_analyst_summary(p_period_id NUMBER
111: , p_credit_type_id NUMBER
112: , p_org_id NUMBER
113: , p_analyst_id NUMBER
114: , p4_a0 out nocopy JTF_NUMBER_TABLE
115: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p4_a3 out nocopy JTF_DATE_TABLE
118: , p4_a4 out nocopy JTF_DATE_TABLE

Line 119: , p4_a5 out nocopy JTF_NUMBER_TABLE

115: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p4_a3 out nocopy JTF_DATE_TABLE
118: , p4_a4 out nocopy JTF_DATE_TABLE
119: , p4_a5 out nocopy JTF_NUMBER_TABLE
120: , p4_a6 out nocopy JTF_NUMBER_TABLE
121: , p4_a7 out nocopy JTF_NUMBER_TABLE
122: );
123: procedure get_salesrep_pe_info(p_salesrep_id NUMBER

Line 120: , p4_a6 out nocopy JTF_NUMBER_TABLE

116: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p4_a3 out nocopy JTF_DATE_TABLE
118: , p4_a4 out nocopy JTF_DATE_TABLE
119: , p4_a5 out nocopy JTF_NUMBER_TABLE
120: , p4_a6 out nocopy JTF_NUMBER_TABLE
121: , p4_a7 out nocopy JTF_NUMBER_TABLE
122: );
123: procedure get_salesrep_pe_info(p_salesrep_id NUMBER
124: , p_period_id NUMBER

Line 121: , p4_a7 out nocopy JTF_NUMBER_TABLE

117: , p4_a3 out nocopy JTF_DATE_TABLE
118: , p4_a4 out nocopy JTF_DATE_TABLE
119: , p4_a5 out nocopy JTF_NUMBER_TABLE
120: , p4_a6 out nocopy JTF_NUMBER_TABLE
121: , p4_a7 out nocopy JTF_NUMBER_TABLE
122: );
123: procedure get_salesrep_pe_info(p_salesrep_id NUMBER
124: , p_period_id NUMBER
125: , p_credit_type_id NUMBER

Line 127: , p4_a0 out nocopy JTF_NUMBER_TABLE

123: procedure get_salesrep_pe_info(p_salesrep_id NUMBER
124: , p_period_id NUMBER
125: , p_credit_type_id NUMBER
126: , p_org_id NUMBER
127: , p4_a0 out nocopy JTF_NUMBER_TABLE
128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 129: , p4_a2 out nocopy JTF_NUMBER_TABLE

125: , p_credit_type_id NUMBER
126: , p_org_id NUMBER
127: , p4_a0 out nocopy JTF_NUMBER_TABLE
128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 130: , p4_a3 out nocopy JTF_NUMBER_TABLE

126: , p_org_id NUMBER
127: , p4_a0 out nocopy JTF_NUMBER_TABLE
128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 131: , p4_a4 out nocopy JTF_NUMBER_TABLE

127: , p4_a0 out nocopy JTF_NUMBER_TABLE
128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 132: , p4_a5 out nocopy JTF_NUMBER_TABLE

128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE

Line 133: , p4_a6 out nocopy JTF_NUMBER_TABLE

129: , p4_a2 out nocopy JTF_NUMBER_TABLE
130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 134: , p4_a7 out nocopy JTF_NUMBER_TABLE

130: , p4_a3 out nocopy JTF_NUMBER_TABLE
131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE
138: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 135: , p4_a8 out nocopy JTF_NUMBER_TABLE

131: , p4_a4 out nocopy JTF_NUMBER_TABLE
132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE
138: , p4_a11 out nocopy JTF_NUMBER_TABLE
139: );

Line 136: , p4_a9 out nocopy JTF_NUMBER_TABLE

132: , p4_a5 out nocopy JTF_NUMBER_TABLE
133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE
138: , p4_a11 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure get_manager_pe_info(p_period_id NUMBER

Line 137: , p4_a10 out nocopy JTF_NUMBER_TABLE

133: , p4_a6 out nocopy JTF_NUMBER_TABLE
134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE
138: , p4_a11 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure get_manager_pe_info(p_period_id NUMBER
141: , p_credit_type_id NUMBER

Line 138: , p4_a11 out nocopy JTF_NUMBER_TABLE

134: , p4_a7 out nocopy JTF_NUMBER_TABLE
135: , p4_a8 out nocopy JTF_NUMBER_TABLE
136: , p4_a9 out nocopy JTF_NUMBER_TABLE
137: , p4_a10 out nocopy JTF_NUMBER_TABLE
138: , p4_a11 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure get_manager_pe_info(p_period_id NUMBER
141: , p_credit_type_id NUMBER
142: , p_org_id NUMBER

Line 143: , p3_a0 out nocopy JTF_NUMBER_TABLE

139: );
140: procedure get_manager_pe_info(p_period_id NUMBER
141: , p_credit_type_id NUMBER
142: , p_org_id NUMBER
143: , p3_a0 out nocopy JTF_NUMBER_TABLE
144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 145: , p3_a2 out nocopy JTF_NUMBER_TABLE

141: , p_credit_type_id NUMBER
142: , p_org_id NUMBER
143: , p3_a0 out nocopy JTF_NUMBER_TABLE
144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 146: , p3_a3 out nocopy JTF_NUMBER_TABLE

142: , p_org_id NUMBER
143: , p3_a0 out nocopy JTF_NUMBER_TABLE
144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 147: , p3_a4 out nocopy JTF_NUMBER_TABLE

143: , p3_a0 out nocopy JTF_NUMBER_TABLE
144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 148: , p3_a5 out nocopy JTF_NUMBER_TABLE

144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE

Line 149: , p3_a6 out nocopy JTF_NUMBER_TABLE

145: , p3_a2 out nocopy JTF_NUMBER_TABLE
146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 150: , p3_a7 out nocopy JTF_NUMBER_TABLE

146: , p3_a3 out nocopy JTF_NUMBER_TABLE
147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE
154: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 151: , p3_a8 out nocopy JTF_NUMBER_TABLE

147: , p3_a4 out nocopy JTF_NUMBER_TABLE
148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE
154: , p3_a11 out nocopy JTF_NUMBER_TABLE
155: );

Line 152: , p3_a9 out nocopy JTF_NUMBER_TABLE

148: , p3_a5 out nocopy JTF_NUMBER_TABLE
149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE
154: , p3_a11 out nocopy JTF_NUMBER_TABLE
155: );
156: procedure get_analyst_pe_info(p_period_id NUMBER

Line 153: , p3_a10 out nocopy JTF_NUMBER_TABLE

149: , p3_a6 out nocopy JTF_NUMBER_TABLE
150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE
154: , p3_a11 out nocopy JTF_NUMBER_TABLE
155: );
156: procedure get_analyst_pe_info(p_period_id NUMBER
157: , p_credit_type_id NUMBER

Line 154: , p3_a11 out nocopy JTF_NUMBER_TABLE

150: , p3_a7 out nocopy JTF_NUMBER_TABLE
151: , p3_a8 out nocopy JTF_NUMBER_TABLE
152: , p3_a9 out nocopy JTF_NUMBER_TABLE
153: , p3_a10 out nocopy JTF_NUMBER_TABLE
154: , p3_a11 out nocopy JTF_NUMBER_TABLE
155: );
156: procedure get_analyst_pe_info(p_period_id NUMBER
157: , p_credit_type_id NUMBER
158: , p_org_id NUMBER

Line 160: , p4_a0 out nocopy JTF_NUMBER_TABLE

156: procedure get_analyst_pe_info(p_period_id NUMBER
157: , p_credit_type_id NUMBER
158: , p_org_id NUMBER
159: , p_analyst_id NUMBER
160: , p4_a0 out nocopy JTF_NUMBER_TABLE
161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 162: , p4_a2 out nocopy JTF_NUMBER_TABLE

158: , p_org_id NUMBER
159: , p_analyst_id NUMBER
160: , p4_a0 out nocopy JTF_NUMBER_TABLE
161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 163: , p4_a3 out nocopy JTF_NUMBER_TABLE

159: , p_analyst_id NUMBER
160: , p4_a0 out nocopy JTF_NUMBER_TABLE
161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 164: , p4_a4 out nocopy JTF_NUMBER_TABLE

160: , p4_a0 out nocopy JTF_NUMBER_TABLE
161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 165: , p4_a5 out nocopy JTF_NUMBER_TABLE

161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE

Line 166: , p4_a6 out nocopy JTF_NUMBER_TABLE

162: , p4_a2 out nocopy JTF_NUMBER_TABLE
163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 167: , p4_a7 out nocopy JTF_NUMBER_TABLE

163: , p4_a3 out nocopy JTF_NUMBER_TABLE
164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE
171: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 168: , p4_a8 out nocopy JTF_NUMBER_TABLE

164: , p4_a4 out nocopy JTF_NUMBER_TABLE
165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE
171: , p4_a11 out nocopy JTF_NUMBER_TABLE
172: );

Line 169: , p4_a9 out nocopy JTF_NUMBER_TABLE

165: , p4_a5 out nocopy JTF_NUMBER_TABLE
166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE
171: , p4_a11 out nocopy JTF_NUMBER_TABLE
172: );
173: procedure get_salesrep_details(p_salesrep_id NUMBER

Line 170: , p4_a10 out nocopy JTF_NUMBER_TABLE

166: , p4_a6 out nocopy JTF_NUMBER_TABLE
167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE
171: , p4_a11 out nocopy JTF_NUMBER_TABLE
172: );
173: procedure get_salesrep_details(p_salesrep_id NUMBER
174: , p_org_id NUMBER

Line 171: , p4_a11 out nocopy JTF_NUMBER_TABLE

167: , p4_a7 out nocopy JTF_NUMBER_TABLE
168: , p4_a8 out nocopy JTF_NUMBER_TABLE
169: , p4_a9 out nocopy JTF_NUMBER_TABLE
170: , p4_a10 out nocopy JTF_NUMBER_TABLE
171: , p4_a11 out nocopy JTF_NUMBER_TABLE
172: );
173: procedure get_salesrep_details(p_salesrep_id NUMBER
174: , p_org_id NUMBER
175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

Line 180: , p2_a5 out nocopy JTF_NUMBER_TABLE

176: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
177: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
179: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
180: , p2_a5 out nocopy JTF_NUMBER_TABLE
181: );
182: procedure get_manager_details(p_org_id NUMBER
183: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
184: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , p1_a5 out nocopy JTF_NUMBER_TABLE

184: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , p1_a5 out nocopy JTF_NUMBER_TABLE
189: );
190: procedure get_analyst_details(p_org_id NUMBER
191: , p_analyst_id NUMBER
192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

Line 197: , p2_a5 out nocopy JTF_NUMBER_TABLE

193: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
194: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
197: , p2_a5 out nocopy JTF_NUMBER_TABLE
198: );
199: procedure get_group_codes(p_org_id NUMBER
200: , x_result_tbl out nocopy JTF_VARCHAR2_TABLE_100
201: );

Line 205: , p3_a0 in out nocopy JTF_NUMBER_TABLE

201: );
202: procedure get_ptd_credit(p_salesrep_id NUMBER
203: , p_payrun_id NUMBER
204: , p_org_id NUMBER
205: , p3_a0 in out nocopy JTF_NUMBER_TABLE
206: , p3_a1 in out nocopy JTF_NUMBER_TABLE
207: );
208: end cn_get_comm_summ_data_pvt_w;

Line 206: , p3_a1 in out nocopy JTF_NUMBER_TABLE

202: procedure get_ptd_credit(p_salesrep_id NUMBER
203: , p_payrun_id NUMBER
204: , p_org_id NUMBER
205: , p3_a0 in out nocopy JTF_NUMBER_TABLE
206: , p3_a1 in out nocopy JTF_NUMBER_TABLE
207: );
208: end cn_get_comm_summ_data_pvt_w;