APPS.CN_SALES_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
8: );
9: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 10: , a1 out nocopy 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
14: );

Line 11: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_DATE_TABLE
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: );

Line 19: , a3 JTF_VARCHAR2_TABLE_100

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
23: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 21: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy 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
23: , a2 out nocopy JTF_VARCHAR2_TABLE_300
24: , a3 out nocopy JTF_VARCHAR2_TABLE_100
25: );

Line 24: , a3 out nocopy 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
28: , p_init_msg_list VARCHAR2

Line 42: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
46: , x_mgr_count out nocopy NUMBER

Line 43: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
46: , x_mgr_count out nocopy NUMBER
47: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 48: , p16_a1 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
52: , x_srp_count out nocopy NUMBER

Line 49: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
52: , x_srp_count out nocopy NUMBER
53: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , p18_a0 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
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

Line 56: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100

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;