DBA Data[Home] [Help]

APPS.CN_RATE_DIMENSIONS_PVT_W dependencies on CN_RATE_DIMENSIONS_PVT

Line 1: package body cn_rate_dimensions_pvt_w as

1: package body cn_rate_dimensions_pvt_w as
2: /* $Header: cnwrdimb.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_rate_dimensions_pvt_w as
2: /* $Header: cnwrdimb.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 38: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

34: end loop;
35: end if;
36: end if;
37: end rosetta_table_copy_in_p1;
38: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_NUMBER_TABLE

Line 102: procedure rosetta_table_copy_in_p2(t out nocopy cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

98: end if;
99: end if;
100: end rosetta_table_copy_out_p1;
101:
102: procedure rosetta_table_copy_in_p2(t out nocopy cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
103: ddindx binary_integer; indx binary_integer;
104: begin
105: if a0 is not null and a0.count > 0 then
106: if a0.count > 0 then

Line 120: procedure rosetta_table_copy_out_p2(t cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

116: end loop;
117: end if;
118: end if;
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_VARCHAR2_TABLE_100();

Line 168: ddp_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type;

164: , x_msg_data out nocopy VARCHAR2
165: )
166:
167: as
168: ddp_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type;
169: ddindx binary_integer; indx binary_integer;
170: begin
171:
172: -- copy data to the local IN or IN-OUT args, if any

Line 181: cn_rate_dimensions_pvt_w.rosetta_table_copy_in_p1(ddp_tiers_tbl, p8_a0

177:
178:
179:
180:
181: cn_rate_dimensions_pvt_w.rosetta_table_copy_in_p1(ddp_tiers_tbl, p8_a0
182: , p8_a1
183: , p8_a2
184: , p8_a3
185: , p8_a4

Line 198: cn_rate_dimensions_pvt.create_dimension(p_api_version,

194:
195:
196:
197: -- here's the delegated call to the old PL/SQL routine
198: cn_rate_dimensions_pvt.create_dimension(p_api_version,
199: p_init_msg_list,
200: p_commit,
201: p_validation_level,
202: p_name,

Line 255: ddp_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type;

251: , x_msg_data out nocopy VARCHAR2
252: )
253:
254: as
255: ddp_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type;
256: ddindx binary_integer; indx binary_integer;
257: begin
258:
259: -- copy data to the local IN or IN-OUT args, if any

Line 269: cn_rate_dimensions_pvt_w.rosetta_table_copy_in_p1(ddp_tiers_tbl, p9_a0

265:
266:
267:
268:
269: cn_rate_dimensions_pvt_w.rosetta_table_copy_in_p1(ddp_tiers_tbl, p9_a0
270: , p9_a1
271: , p9_a2
272: , p9_a3
273: , p9_a4

Line 286: cn_rate_dimensions_pvt.update_dimension(p_api_version,

282:
283:
284:
285: -- here's the delegated call to the old PL/SQL routine
286: cn_rate_dimensions_pvt.update_dimension(p_api_version,
287: p_init_msg_list,
288: p_commit,
289: p_validation_level,
290: p_rate_dimension_id,

Line 319: end cn_rate_dimensions_pvt_w;

315:
316:
317: end;
318:
319: end cn_rate_dimensions_pvt_w;