APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 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

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

Line 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

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
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

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

Line 183: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400

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

Line 192: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

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