1: package body as_scorecard_rules_pub_w as
2: /* $Header: asxwscob.pls 120.2 2006/03/09 15:41 solin 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:
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 as_scorecard_rules_pub.cardrule_qual_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
73: end loop;
74: end if;
75: end if;
76: end rosetta_table_copy_in_p2;
77: procedure rosetta_table_copy_out_p2(t as_scorecard_rules_pub.cardrule_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_DATE_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_DATE_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
208: , p7_a9 DATE := fnd_api.g_miss_date
209: )
210:
211: as
212: ddp_scorecard_rec as_scorecard_rules_pub.scorecard_rec_type;
213: ddindx binary_integer; indx binary_integer;
214: begin
215:
216: -- copy data to the local IN or IN-OUT args, if any
233: ddp_scorecard_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a9);
234:
235:
236: -- here's the delegated call to the old PL/SQL routine
237: as_scorecard_rules_pub.create_scorecard(p_api_version,
238: p_init_msg_list,
239: p_commit,
240: p_validation_level,
241: x_return_status,
274: , p7_a9 DATE := fnd_api.g_miss_date
275: )
276:
277: as
278: ddp_scorecard_rec as_scorecard_rules_pub.scorecard_rec_type;
279: ddindx binary_integer; indx binary_integer;
280: begin
281:
282: -- copy data to the local IN or IN-OUT args, if any
298: ddp_scorecard_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a8);
299: ddp_scorecard_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a9);
300:
301: -- here's the delegated call to the old PL/SQL routine
302: as_scorecard_rules_pub.update_scorecard(p_api_version,
303: p_init_msg_list,
304: p_commit,
305: p_validation_level,
306: x_return_status,
347: , p7_a18 DATE := fnd_api.g_miss_date
348: )
349:
350: as
351: ddp_cardrule_qual_rec as_scorecard_rules_pub.cardrule_qual_rec_type;
352: ddindx binary_integer; indx binary_integer;
353: begin
354:
355: -- copy data to the local IN or IN-OUT args, if any
381: ddp_cardrule_qual_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a18);
382:
383:
384: -- here's the delegated call to the old PL/SQL routine
385: as_scorecard_rules_pub.create_cardrule_qual(p_api_version,
386: p_init_msg_list,
387: p_commit,
388: p_validation_level,
389: x_return_status,
431: , p7_a18 DATE := fnd_api.g_miss_date
432: )
433:
434: as
435: ddp_cardrule_qual_rec as_scorecard_rules_pub.cardrule_qual_rec_type;
436: ddindx binary_integer; indx binary_integer;
437: begin
438:
439: -- copy data to the local IN or IN-OUT args, if any
464: ddp_cardrule_qual_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a17);
465: ddp_cardrule_qual_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a18);
466:
467: -- here's the delegated call to the old PL/SQL routine
468: as_scorecard_rules_pub.update_cardrule_qual(p_api_version,
469: p_init_msg_list,
470: p_commit,
471: p_validation_level,
472: x_return_status,
483:
484:
485: end;
486:
487: end as_scorecard_rules_pub_w;