DBA Data[Home] [Help]

APPS.PV_PEC_RULES_PVT_W dependencies on PV_PEC_RULES_PVT

Line 1: package body pv_pec_rules_pvt_w as

1: package body pv_pec_rules_pvt_w as
2: /* $Header: pvxwecrb.pls 120.3 2005/09/14 06:10 rdsharma 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 22: procedure rosetta_table_copy_in_p2(t out nocopy pv_pec_rules_pvt.pec_rules_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy pv_pec_rules_pvt.pec_rules_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 65: procedure rosetta_table_copy_out_p2(t pv_pec_rules_pvt.pec_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p2;
65: procedure rosetta_table_copy_out_p2(t pv_pec_rules_pvt.pec_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 173: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;

169: , p7_a12 NUMBER := 0-1962.0724
170: )
171:
172: as
173: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;
174: ddindx binary_integer; indx binary_integer;
175: begin
176:
177: -- copy data to the local IN or IN-OUT args, if any

Line 201: pv_pec_rules_pvt.create_pec_rules(p_api_version_number,

197: ddp_pec_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a12);
198:
199:
200: -- here's the delegated call to the old PL/SQL routine
201: pv_pec_rules_pvt.create_pec_rules(p_api_version_number,
202: p_init_msg_list,
203: p_commit,
204: p_validation_level,
205: x_return_status,

Line 246: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;

242: , p7_a12 NUMBER := 0-1962.0724
243: )
244:
245: as
246: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:
250: -- copy data to the local IN or IN-OUT args, if any

Line 274: pv_pec_rules_pvt.update_pec_rules(p_api_version_number,

270: ddp_pec_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a12);
271:
272:
273: -- here's the delegated call to the old PL/SQL routine
274: pv_pec_rules_pvt.update_pec_rules(p_api_version_number,
275: p_init_msg_list,
276: p_commit,
277: p_validation_level,
278: x_return_status,

Line 318: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;

314: , p3_a12 NUMBER := 0-1962.0724
315: )
316:
317: as
318: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;
319: ddindx binary_integer; indx binary_integer;
320: begin
321:
322: -- copy data to the local IN or IN-OUT args, if any

Line 345: pv_pec_rules_pvt.validate_pec_rules(p_api_version_number,

341:
342:
343:
344: -- here's the delegated call to the old PL/SQL routine
345: pv_pec_rules_pvt.validate_pec_rules(p_api_version_number,
346: p_init_msg_list,
347: p_validation_level,
348: ddp_pec_rules_rec,
349: p_validation_mode,

Line 382: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;

378: , p0_a12 NUMBER := 0-1962.0724
379: )
380:
381: as
382: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:
386: -- copy data to the local IN or IN-OUT args, if any

Line 404: pv_pec_rules_pvt.check_pec_rules_items(ddp_pec_rules_rec,

400:
401:
402:
403: -- here's the delegated call to the old PL/SQL routine
404: pv_pec_rules_pvt.check_pec_rules_items(ddp_pec_rules_rec,
405: p_validation_mode,
406: x_return_status);
407:
408: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 434: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;

430: , p5_a12 NUMBER := 0-1962.0724
431: )
432:
433: as
434: ddp_pec_rules_rec pv_pec_rules_pvt.pec_rules_rec_type;
435: ddindx binary_integer; indx binary_integer;
436: begin
437:
438: -- copy data to the local IN or IN-OUT args, if any

Line 459: pv_pec_rules_pvt.validate_pec_rules_rec(p_api_version_number,

455: ddp_pec_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
456: ddp_pec_rules_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
457:
458: -- here's the delegated call to the old PL/SQL routine
459: pv_pec_rules_pvt.validate_pec_rules_rec(p_api_version_number,
460: p_init_msg_list,
461: x_return_status,
462: x_msg_count,
463: x_msg_data,

Line 474: end pv_pec_rules_pvt_w;

470:
471:
472: end;
473:
474: end pv_pec_rules_pvt_w;