APPS.AHL_FMP_EFFECTIVITY_DTL_PVT_W dependencies on AHL_FMP_EFFECTIVITY_DTL_PVT

Line 1: package body ahl_fmp_effectivity_dtl_pvt_w as

1: package body ahl_fmp_effectivity_dtl_pvt_w as
2: /* $Header: AHLWMEDB.pls 120.1 2005/08/17 08:58:27 pbarman noship $ */
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_effectivity_dtl_pvt.effectivity_detail_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_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 330: ddp_x_effectivity_detail_tbl ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type;

326: , p_mr_effectivity_id NUMBER
327: )
328:
329: as
330: ddp_x_effectivity_detail_tbl ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:
334: -- copy data to the local IN or IN-OUT args, if any

Line 344: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_detail_tbl, p9_a0

340:
341:
342:
343:
344: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_detail_tbl, p9_a0
345: , p9_a1
346: , p9_a2
347: , p9_a3
348: , p9_a4

Line 382: ahl_fmp_effectivity_dtl_pvt.process_effectivity_detail(p_api_version,

378:
379:
380:
381: -- here's the delegated call to the old PL/SQL routine
382: ahl_fmp_effectivity_dtl_pvt.process_effectivity_detail(p_api_version,
383: p_init_msg_list,
384: p_commit,
385: p_validation_level,
386: p_default,

Line 405: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_detail_tbl, p9_a0

401:
402:
403:
404:
405: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_detail_tbl, p9_a0
406: , p9_a1
407: , p9_a2
408: , p9_a3
409: , p9_a4

Line 443: end ahl_fmp_effectivity_dtl_pvt_w;

439:
440:
441: end;
442:
443: end ahl_fmp_effectivity_dtl_pvt_w;