APPS.CN_SALES_HIER_PUB_W dependencies on CN_SALES_HIER_PUB

Line 1: package body cn_sales_hier_pub_w as

1: package body cn_sales_hier_pub_w as
2: /* $Header: cnwhierb.pls 115.5 2002/11/25 23:57:30 fting ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE

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

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE

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

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_VARCHAR2_TABLE_300
87: , a3 JTF_VARCHAR2_TABLE_100
88: ) as

Line 109: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

105: end loop;
106: end if;
107: end if;
108: end rosetta_table_copy_in_p3;
109: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_300
112: , a3 out nocopy JTF_VARCHAR2_TABLE_100
113: ) as

Line 183: ddx_mgr_tbl cn_sales_hier_pub.hier_tbl_type;

179: )
180:
181: as
182: ddp_date date;
183: ddx_mgr_tbl cn_sales_hier_pub.hier_tbl_type;
184: ddx_srp_tbl cn_sales_hier_pub.hier_tbl_type;
185: ddx_grp_tbl cn_sales_hier_pub.grp_tbl_type;
186: ddindx binary_integer; indx binary_integer;
187: begin

Line 184: ddx_srp_tbl cn_sales_hier_pub.hier_tbl_type;

180:
181: as
182: ddp_date date;
183: ddx_mgr_tbl cn_sales_hier_pub.hier_tbl_type;
184: ddx_srp_tbl cn_sales_hier_pub.hier_tbl_type;
185: ddx_grp_tbl cn_sales_hier_pub.grp_tbl_type;
186: ddindx binary_integer; indx binary_integer;
187: begin
188:

Line 185: ddx_grp_tbl cn_sales_hier_pub.grp_tbl_type;

181: as
182: ddp_date date;
183: ddx_mgr_tbl cn_sales_hier_pub.hier_tbl_type;
184: ddx_srp_tbl cn_sales_hier_pub.hier_tbl_type;
185: ddx_grp_tbl cn_sales_hier_pub.grp_tbl_type;
186: ddindx binary_integer; indx binary_integer;
187: begin
188:
189: -- copy data to the local IN or IN-OUT args, if any

Line 212: cn_sales_hier_pub.get_sales_hier(p_api_version,

208:
209:
210:
211: -- here's the delegated call to the old PL/SQL routine
212: cn_sales_hier_pub.get_sales_hier(p_api_version,
213: p_init_msg_list,
214: p_validation_level,
215: x_return_status,
216: x_msg_count,

Line 248: cn_sales_hier_pub_w.rosetta_table_copy_out_p1(ddx_mgr_tbl, p14_a0

244:
245:
246:
247:
248: cn_sales_hier_pub_w.rosetta_table_copy_out_p1(ddx_mgr_tbl, p14_a0
249: , p14_a1
250: , p14_a2
251: , p14_a3
252: , p14_a4

Line 256: cn_sales_hier_pub_w.rosetta_table_copy_out_p1(ddx_srp_tbl, p16_a0

252: , p14_a4
253: );
254:
255:
256: cn_sales_hier_pub_w.rosetta_table_copy_out_p1(ddx_srp_tbl, p16_a0
257: , p16_a1
258: , p16_a2
259: , p16_a3
260: , p16_a4

Line 264: cn_sales_hier_pub_w.rosetta_table_copy_out_p3(ddx_grp_tbl, p18_a0

260: , p16_a4
261: );
262:
263:
264: cn_sales_hier_pub_w.rosetta_table_copy_out_p3(ddx_grp_tbl, p18_a0
265: , p18_a1
266: , p18_a2
267: , p18_a3
268: );

Line 272: end cn_sales_hier_pub_w;

268: );
269:
270: end;
271:
272: end cn_sales_hier_pub_w;