APPS.AHL_FMP_MR_EFFECTIVITY_PVT_W dependencies on AHL_FMP_MR_EFFECTIVITY_PVT

Line 1: package body ahl_fmp_mr_effectivity_pvt_w as

1: package body ahl_fmp_mr_effectivity_pvt_w as
2: /* $Header: AHLWMREB.pls 120.0.12020000.2 2012/12/13 06:11:07 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_p1(t out nocopy ahl_fmp_mr_effectivity_pvt.effectivity_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_p1(t out nocopy ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_1000
20: , a4 JTF_NUMBER_TABLE

Line 103: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p1;
103: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_100
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_1000
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 346: ddp_x_effectivity_tbl ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type;

342: , p_super_user VARCHAR2
343: )
344:
345: as
346: ddp_x_effectivity_tbl ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any

Line 360: ahl_fmp_mr_effectivity_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_tbl, p9_a0

356:
357:
358:
359:
360: ahl_fmp_mr_effectivity_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_tbl, p9_a0
361: , p9_a1
362: , p9_a2
363: , p9_a3
364: , p9_a4

Line 400: ahl_fmp_mr_effectivity_pvt.process_effectivity(p_api_version,

396:
397:
398:
399: -- here's the delegated call to the old PL/SQL routine
400: ahl_fmp_mr_effectivity_pvt.process_effectivity(p_api_version,
401: p_init_msg_list,
402: p_commit,
403: p_validation_level,
404: p_default,

Line 423: ahl_fmp_mr_effectivity_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_tbl, p9_a0

419:
420:
421:
422:
423: ahl_fmp_mr_effectivity_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_tbl, p9_a0
424: , p9_a1
425: , p9_a2
426: , p9_a3
427: , p9_a4

Line 463: end ahl_fmp_mr_effectivity_pvt_w;

459:
460:
461: end;
462:
463: end ahl_fmp_mr_effectivity_pvt_w;