DBA Data[Home] [Help]

APPS.AMS_IMPORT_LIST_PVT_W dependencies on AMS_IMPORT_LIST_PVT

Line 1: package body ams_import_list_pvt_w as

1: package body ams_import_list_pvt_w as
2: /* $Header: amswimpb.pls 120.1 2006/01/02 01:28 rmbhanda 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:

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_list_pvt.ams_import_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_list_pvt.ams_import_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 191: procedure rosetta_table_copy_out_p3(t ams_import_list_pvt.ams_import_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

187: end loop;
188: end if;
189: end if;
190: end rosetta_table_copy_in_p3;
191: procedure rosetta_table_copy_out_p3(t ams_import_list_pvt.ams_import_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_DATE_TABLE
193: , a2 out nocopy JTF_NUMBER_TABLE
194: , a3 out nocopy JTF_DATE_TABLE
195: , a4 out nocopy JTF_NUMBER_TABLE

Line 678: ddx_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

674: , x_file_type out nocopy VARCHAR2
675: )
676:
677: as
678: ddx_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
679: ddindx binary_integer; indx binary_integer;
680: begin
681:
682: -- copy data to the local IN or IN-OUT args, if any

Line 694: ams_import_list_pvt.duplicate_import_list(p_api_version_number,

690:
691:
692:
693: -- here's the delegated call to the old PL/SQL routine
694: ams_import_list_pvt.duplicate_import_list(p_api_version_number,
695: p_init_msg_list,
696: p_commit,
697: p_validation_level,
698: x_return_status,

Line 880: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

876: , p7_a75 VARCHAR2 := fnd_api.g_miss_char
877: )
878:
879: as
880: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
881: ddindx binary_integer; indx binary_integer;
882: begin
883:
884: -- copy data to the local IN or IN-OUT args, if any

Line 971: ams_import_list_pvt.create_import_list(p_api_version_number,

967: ddp_ams_import_rec.charset := p7_a75;
968:
969:
970: -- here's the delegated call to the old PL/SQL routine
971: ams_import_list_pvt.create_import_list(p_api_version_number,
972: p_init_msg_list,
973: p_commit,
974: p_validation_level,
975: x_return_status,

Line 1079: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

1075: , p7_a75 VARCHAR2 := fnd_api.g_miss_char
1076: )
1077:
1078: as
1079: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
1080: ddindx binary_integer; indx binary_integer;
1081: begin
1082:
1083: -- copy data to the local IN or IN-OUT args, if any

Line 1170: ams_import_list_pvt.update_import_list(p_api_version_number,

1166: ddp_ams_import_rec.charset := p7_a75;
1167:
1168:
1169: -- here's the delegated call to the old PL/SQL routine
1170: ams_import_list_pvt.update_import_list(p_api_version_number,
1171: p_init_msg_list,
1172: p_commit,
1173: p_validation_level,
1174: x_return_status,

Line 1276: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

1272: , p3_a75 VARCHAR2 := fnd_api.g_miss_char
1273: )
1274:
1275: as
1276: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
1277: ddindx binary_integer; indx binary_integer;
1278: begin
1279:
1280: -- copy data to the local IN or IN-OUT args, if any

Line 1365: ams_import_list_pvt.validate_import_list(p_api_version_number,

1361:
1362:
1363:
1364: -- here's the delegated call to the old PL/SQL routine
1365: ams_import_list_pvt.validate_import_list(p_api_version_number,
1366: p_init_msg_list,
1367: p_validation_level,
1368: ddp_ams_import_rec,
1369: x_return_status,

Line 1463: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

1459: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1460: )
1461:
1462: as
1463: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
1464: ddindx binary_integer; indx binary_integer;
1465: begin
1466:
1467: -- copy data to the local IN or IN-OUT args, if any

Line 1548: ams_import_list_pvt.check_ams_import_items(ddp_ams_import_rec,

1544:
1545:
1546:
1547: -- here's the delegated call to the old PL/SQL routine
1548: ams_import_list_pvt.check_ams_import_items(ddp_ams_import_rec,
1549: p_validation_mode,
1550: x_return_status);
1551:
1552: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1641: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;

1637: , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1638: )
1639:
1640: as
1641: ddp_ams_import_rec ams_import_list_pvt.ams_import_rec_type;
1642: ddindx binary_integer; indx binary_integer;
1643: begin
1644:
1645: -- copy data to the local IN or IN-OUT args, if any

Line 1729: ams_import_list_pvt.validate_ams_import_rec(p_api_version_number,

1725: ddp_ams_import_rec.error_threshold := rosetta_g_miss_num_map(p5_a74);
1726: ddp_ams_import_rec.charset := p5_a75;
1727:
1728: -- here's the delegated call to the old PL/SQL routine
1729: ams_import_list_pvt.validate_ams_import_rec(p_api_version_number,
1730: p_init_msg_list,
1731: x_return_status,
1732: x_msg_count,
1733: x_msg_data,

Line 1744: end ams_import_list_pvt_w;

1740:
1741:
1742: end;
1743:
1744: end ams_import_list_pvt_w;