DBA Data[Home] [Help]

APPS.AHL_FMP_MR_INTERVAL_PVT_W dependencies on AHL_FMP_MR_INTERVAL_PVT

Line 1: package body ahl_fmp_mr_interval_pvt_w as

1: package body ahl_fmp_mr_interval_pvt_w as
2: /* $Header: AHLWMITB.pls 120.3.12020000.2 2012/12/13 05:55:58 shnatu 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 107: procedure rosetta_table_copy_out_p2(t ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE

Line 367: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;

363: , p_super_user VARCHAR2
364: )
365:
366: as
367: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;
368: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;
369: ddindx binary_integer; indx binary_integer;
370: begin
371:

Line 368: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;

364: )
365:
366: as
367: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;
368: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;
369: ddindx binary_integer; indx binary_integer;
370: begin
371:
372: -- copy data to the local IN or IN-OUT args, if any

Line 382: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_in_p2(ddp_x_interval_tbl, p9_a0

378:
379:
380:
381:
382: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_in_p2(ddp_x_interval_tbl, p9_a0
383: , p9_a1
384: , p9_a2
385: , p9_a3
386: , p9_a4

Line 430: ahl_fmp_mr_interval_pvt.process_interval(p_api_version,

426:
427:
428:
429: -- here's the delegated call to the old PL/SQL routine
430: ahl_fmp_mr_interval_pvt.process_interval(p_api_version,
431: p_init_msg_list,
432: p_commit,
433: p_validation_level,
434: p_default,

Line 454: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_out_p2(ddp_x_interval_tbl, p9_a0

450:
451:
452:
453:
454: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_out_p2(ddp_x_interval_tbl, p9_a0
455: , p9_a1
456: , p9_a2
457: , p9_a3
458: , p9_a4

Line 502: end ahl_fmp_mr_interval_pvt_w;

498:
499:
500: end;
501:
502: end ahl_fmp_mr_interval_pvt_w;