APPS.AHL_PRD_SERN_CHANGE_PVT_W dependencies on AHL_PRD_SERN_CHANGE_PVT

Line 1: package body ahl_prd_sern_change_pvt_w as

1: package body ahl_prd_sern_change_pvt_w as
2: /* $Header: AHLWSNCB.pls 120.2 2008/03/06 00:24:36 adivenka 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_prd_sern_change_pvt.sernum_change_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_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

55: end loop;
56: end if;
57: end if;
58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: ddp_serialnum_change_rec ahl_prd_sern_change_pvt.sernum_change_rec_type;

163: , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
164: )
165:
166: as
167: ddp_serialnum_change_rec ahl_prd_sern_change_pvt.sernum_change_rec_type;
168: ddx_warning_msg_tbl ahl_uc_validation_pub.error_tbl_type;
169: ddindx binary_integer; indx binary_integer;
170: begin
171:

Line 196: ahl_prd_sern_change_pvt.process_serialnum_change(p_api_version,

192:
193:
194:
195: -- here's the delegated call to the old PL/SQL routine
196: ahl_prd_sern_change_pvt.process_serialnum_change(p_api_version,
197: p_init_msg_list,
198: p_commit,
199: p_validation_level,
200: ddp_serialnum_change_rec,

Line 218: end ahl_prd_sern_change_pvt_w;

214:
215: ahl_uc_validation_pub_w.rosetta_table_copy_out_p0(ddx_warning_msg_tbl, x_warning_msg_tbl);
216: end;
217:
218: end ahl_prd_sern_change_pvt_w;