APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400

293: end if;
294: end if;
295: end rosetta_table_copy_out_p5;
296:
297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100

Line 326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400

322: end loop;
323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 336: a0 := JTF_VARCHAR2_TABLE_400();

332: ) as
333: ddindx binary_integer; indx binary_integer;
334: begin
335: if t is null or t.count = 0 then
336: a0 := JTF_VARCHAR2_TABLE_400();
337: a1 := JTF_VARCHAR2_TABLE_100();
338: a2 := JTF_VARCHAR2_TABLE_100();
339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();

Line 343: a0 := JTF_VARCHAR2_TABLE_400();

339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();
342: else
343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_VARCHAR2_TABLE_100();
346: a3 := JTF_VARCHAR2_TABLE_100();
347: a4 := JTF_VARCHAR2_TABLE_100();

Line 772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

768: end;
769:
770: procedure get_salesrep_details(p_salesrep_id NUMBER
771: , p_org_id NUMBER
772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400

803: );
804: end;
805:
806: procedure get_manager_details(p_org_id NUMBER
807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400

836: end;
837:
838: procedure get_analyst_details(p_org_id NUMBER
839: , p_analyst_id NUMBER
840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100