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.2 2007/10/30 23:11:21 sikumar 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 103: procedure rosetta_table_copy_out_p2(t ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 351: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;

347: , p_super_user VARCHAR2
348: )
349:
350: as
351: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;
352: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;
353: ddindx binary_integer; indx binary_integer;
354: begin
355:

Line 352: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;

348: )
349:
350: as
351: ddp_x_interval_tbl ahl_fmp_mr_interval_pvt.interval_tbl_type;
352: ddp_x_threshold_rec ahl_fmp_mr_interval_pvt.threshold_rec_type;
353: ddindx binary_integer; indx binary_integer;
354: begin
355:
356: -- copy data to the local IN or IN-OUT args, if any

Line 366: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_in_p2(ddp_x_interval_tbl, p9_a0

362:
363:
364:
365:
366: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_in_p2(ddp_x_interval_tbl, p9_a0
367: , p9_a1
368: , p9_a2
369: , p9_a3
370: , p9_a4

Line 412: ahl_fmp_mr_interval_pvt.process_interval(p_api_version,

408:
409:
410:
411: -- here's the delegated call to the old PL/SQL routine
412: ahl_fmp_mr_interval_pvt.process_interval(p_api_version,
413: p_init_msg_list,
414: p_commit,
415: p_validation_level,
416: p_default,

Line 436: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_out_p2(ddp_x_interval_tbl, p9_a0

432:
433:
434:
435:
436: ahl_fmp_mr_interval_pvt_w.rosetta_table_copy_out_p2(ddp_x_interval_tbl, p9_a0
437: , p9_a1
438: , p9_a2
439: , p9_a3
440: , p9_a4

Line 482: end ahl_fmp_mr_interval_pvt_w;

478:
479:
480: end;
481:
482: end ahl_fmp_mr_interval_pvt_w;