DBA Data[Home] [Help]

APPS.CN_RULE_PVT_W dependencies on CN_RULE_PVT

Line 1: package body cn_rule_pvt_w as

1: package body cn_rule_pvt_w as
2: /* $Header: cnwrruleb.pls 120.2 2005/06/17 04:10 appldev $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy cn_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_rule_pvt_w as
2: /* $Header: cnwrruleb.pls 120.2 2005/06/17 04:10 appldev $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_2000

Line 48: procedure rosetta_table_copy_out_p2(t cn_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p2;
48: procedure rosetta_table_copy_out_p2(t cn_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 159: ddp_rule_rec cn_rule_pvt.rule_rec_type;

155: , x_rule_id out nocopy NUMBER
156: )
157:
158: as
159: ddp_rule_rec cn_rule_pvt.rule_rec_type;
160: ddindx binary_integer; indx binary_integer;
161: begin
162:
163: -- copy data to the local IN or IN-OUT args, if any

Line 185: cn_rule_pvt.create_rule(p_api_version,

181: ddp_rule_rec.object_version_no := p8_a9;
182:
183:
184: -- here's the delegated call to the old PL/SQL routine
185: cn_rule_pvt.create_rule(p_api_version,
186: p_init_msg_list,
187: p_commit,
188: p_validation_level,
189: x_return_status,

Line 239: ddp_old_rule_rec cn_rule_pvt.rule_rec_type;

235: , p9_a9 NUMBER
236: )
237:
238: as
239: ddp_old_rule_rec cn_rule_pvt.rule_rec_type;
240: ddp_rule_rec cn_rule_pvt.rule_rec_type;
241: ddindx binary_integer; indx binary_integer;
242: begin
243:

Line 240: ddp_rule_rec cn_rule_pvt.rule_rec_type;

236: )
237:
238: as
239: ddp_old_rule_rec cn_rule_pvt.rule_rec_type;
240: ddp_rule_rec cn_rule_pvt.rule_rec_type;
241: ddindx binary_integer; indx binary_integer;
242: begin
243:
244: -- copy data to the local IN or IN-OUT args, if any

Line 276: cn_rule_pvt.update_rule(p_api_version,

272: ddp_rule_rec.org_id := p9_a8;
273: ddp_rule_rec.object_version_no := p9_a9;
274:
275: -- here's the delegated call to the old PL/SQL routine
276: cn_rule_pvt.update_rule(p_api_version,
277: p_init_msg_list,
278: p_commit,
279: p_validation_level,
280: x_return_status,

Line 331: ddx_rule_tbl cn_rule_pvt.rule_tbl_type;

327: , p_org_id NUMBER
328: )
329:
330: as
331: ddx_rule_tbl cn_rule_pvt.rule_tbl_type;
332: ddindx binary_integer; indx binary_integer;
333: begin
334:
335: -- copy data to the local IN or IN-OUT args, if any

Line 353: cn_rule_pvt.get_rules(p_api_version,

349:
350:
351:
352: -- here's the delegated call to the old PL/SQL routine
353: cn_rule_pvt.get_rules(p_api_version,
354: p_init_msg_list,
355: p_commit,
356: p_validation_level,
357: x_return_status,

Line 382: cn_rule_pvt_w.rosetta_table_copy_out_p2(ddx_rule_tbl, p11_a0

378:
379:
380:
381:
382: cn_rule_pvt_w.rosetta_table_copy_out_p2(ddx_rule_tbl, p11_a0
383: , p11_a1
384: , p11_a2
385: , p11_a3
386: , p11_a4

Line 403: end cn_rule_pvt_w;

399:
400:
401: end;
402:
403: end cn_rule_pvt_w;