DBA Data[Home] [Help]

APPS.CN_SALES_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300

1: package cn_sales_hier_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwhiers.pls 115.6 2002/11/25 23:56:59 fting ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 9: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: );
9: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_DATE_TABLE

Line 18: , a2 JTF_VARCHAR2_TABLE_300

14: );
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_VARCHAR2_TABLE_100
20: );
21: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
22: , a1 out nocopy JTF_NUMBER_TABLE

Line 23: , a2 out nocopy JTF_VARCHAR2_TABLE_300

19: , a3 JTF_VARCHAR2_TABLE_100
20: );
21: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
22: , a1 out nocopy JTF_NUMBER_TABLE
23: , a2 out nocopy JTF_VARCHAR2_TABLE_300
24: , a3 out nocopy JTF_VARCHAR2_TABLE_100
25: );
26:
27: procedure get_sales_hier(p_api_version NUMBER

Line 41: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300

37: , p_start_record NUMBER
38: , p_increment_count NUMBER
39: , p_start_record_grp NUMBER
40: , p_increment_count_grp NUMBER
41: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
42: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , p14_a3 out nocopy JTF_DATE_TABLE
45: , p14_a4 out nocopy JTF_DATE_TABLE

Line 47: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300

43: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , p14_a3 out nocopy JTF_DATE_TABLE
45: , p14_a4 out nocopy JTF_DATE_TABLE
46: , x_mgr_count out nocopy NUMBER
47: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
48: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
49: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
50: , p16_a3 out nocopy JTF_DATE_TABLE
51: , p16_a4 out nocopy JTF_DATE_TABLE

Line 55: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300

51: , p16_a4 out nocopy JTF_DATE_TABLE
52: , x_srp_count out nocopy NUMBER
53: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p18_a1 out nocopy JTF_NUMBER_TABLE
55: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
56: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100
57: , x_grp_count out nocopy NUMBER
58: );
59: end cn_sales_hier_pub_w;