APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
17: , a5 out nocopy JTF_NUMBER_TABLE

Line 14: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_NUMBER_TABLE

Line 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);

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

Line 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);

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

Line 29: , a1 JTF_VARCHAR2_TABLE_100

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
33: , a5 JTF_NUMBER_TABLE

Line 42: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
46: , a5 out nocopy JTF_NUMBER_TABLE

Line 56: , a1 JTF_VARCHAR2_TABLE_100

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
57: , a2 JTF_VARCHAR2_TABLE_100
58: , a3 JTF_VARCHAR2_TABLE_100
59: , a4 JTF_VARCHAR2_TABLE_100
60: , a5 JTF_NUMBER_TABLE

Line 57: , a2 JTF_VARCHAR2_TABLE_100

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
57: , a2 JTF_VARCHAR2_TABLE_100
58: , a3 JTF_VARCHAR2_TABLE_100
59: , a4 JTF_VARCHAR2_TABLE_100
60: , a5 JTF_NUMBER_TABLE
61: );

Line 58: , a3 JTF_VARCHAR2_TABLE_100

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

Line 59: , a4 JTF_VARCHAR2_TABLE_100

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

Line 63: , a1 out nocopy 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
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_100
67: , a5 out nocopy JTF_NUMBER_TABLE

Line 64: , a2 out nocopy 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
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_100
67: , a5 out nocopy JTF_NUMBER_TABLE
68: );

Line 65: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 66: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 90: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
94: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 91: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
94: , p4_a5 out nocopy JTF_NUMBER_TABLE
95: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 102: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
106: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 103: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
106: , p3_a5 out nocopy JTF_NUMBER_TABLE
107: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 115: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
119: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 116: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
119: , p4_a5 out nocopy JTF_NUMBER_TABLE
120: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 128: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
132: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 144: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
148: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 161: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
165: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 176: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

172: );
173: procedure get_salesrep_details(p_salesrep_id NUMBER
174: , p_org_id NUMBER
175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 177: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

173: procedure get_salesrep_details(p_salesrep_id NUMBER
174: , p_org_id NUMBER
175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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: );

Line 178: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

174: , p_org_id NUMBER
175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 179: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100

175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 184: , p1_a1 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
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

Line 185: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 186: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 187: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

183: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 193: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

189: );
190: procedure get_analyst_details(p_org_id NUMBER
191: , p_analyst_id NUMBER
192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 194: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

190: procedure get_analyst_details(p_org_id NUMBER
191: , p_analyst_id NUMBER
192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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: );

Line 195: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

191: , p_analyst_id NUMBER
192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 196: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100

192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 200: , x_result_tbl 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: );
202: procedure get_ptd_credit(p_salesrep_id NUMBER
203: , p_payrun_id NUMBER
204: , p_org_id NUMBER