DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNER_PVT_W dependencies on AMS_ITEM_OWNER_PVT

Line 1: package body ams_item_owner_pvt_w as

1: package body ams_item_owner_pvt_w as
2: /* $Header: amswinvb.pls 120.3 2006/05/04 03:17 inanaiah 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 25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300

Line 64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

60: end loop;
61: end if;
62: end if;
63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 138: procedure rosetta_table_copy_in_p8(t out nocopy ams_item_owner_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE

134: end if;
135: end if;
136: end rosetta_table_copy_out_p3;
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy ams_item_owner_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_VARCHAR2_TABLE_100
141: , a3 JTF_VARCHAR2_TABLE_2000
142: , a4 JTF_VARCHAR2_TABLE_100

Line 169: procedure rosetta_table_copy_out_p8(t ams_item_owner_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

165: end loop;
166: end if;
167: end if;
168: end rosetta_table_copy_in_p8;
169: procedure rosetta_table_copy_out_p8(t ams_item_owner_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a1 out nocopy JTF_NUMBER_TABLE
171: , a2 out nocopy JTF_VARCHAR2_TABLE_100
172: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 387: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;

383: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
384: )
385:
386: as
387: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
388: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
389: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
390: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
391: ddindx binary_integer; indx binary_integer;

Line 388: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;

384: )
385:
386: as
387: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
388: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
389: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
390: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
391: ddindx binary_integer; indx binary_integer;
392: begin

Line 389: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;

385:
386: as
387: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
388: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
389: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
390: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
391: ddindx binary_integer; indx binary_integer;
392: begin
393:

Line 390: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;

386: as
387: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
388: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
389: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
390: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
391: ddindx binary_integer; indx binary_integer;
392: begin
393:
394: -- copy data to the local IN or IN-OUT args, if any

Line 487: ams_item_owner_pvt.create_item_owner(p_api_version_number,

483:
484:
485:
486: -- here's the delegated call to the old PL/SQL routine
487: ams_item_owner_pvt.create_item_owner(p_api_version_number,
488: p_init_msg_list,
489: p_commit,
490: p_validation_level,
491: x_return_status,

Line 581: ams_item_owner_pvt_w.rosetta_table_copy_out_p8(ddx_error_tbl, p12_a0

577: p10_a65 := ddp_item_rec_out.attribute14;
578: p10_a66 := ddp_item_rec_out.attribute15;
579:
580:
581: ams_item_owner_pvt_w.rosetta_table_copy_out_p8(ddx_error_tbl, p12_a0
582: , p12_a1
583: , p12_a2
584: , p12_a3
585: , p12_a4

Line 755: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;

751: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
752: )
753:
754: as
755: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
756: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
757: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
758: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
759: ddindx binary_integer; indx binary_integer;

Line 756: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;

752: )
753:
754: as
755: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
756: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
757: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
758: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin

Line 757: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;

753:
754: as
755: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
756: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
757: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
758: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin
761:

Line 758: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;

754: as
755: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
756: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
757: ddp_item_rec_out ams_item_owner_pvt.item_rec_type;
758: ddx_error_tbl ams_item_owner_pvt.error_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin
761:
762: -- copy data to the local IN or IN-OUT args, if any

Line 855: ams_item_owner_pvt.update_item_owner(p_api_version_number,

851:
852:
853:
854: -- here's the delegated call to the old PL/SQL routine
855: ams_item_owner_pvt.update_item_owner(p_api_version_number,
856: p_init_msg_list,
857: p_commit,
858: p_validation_level,
859: x_return_status,

Line 949: ams_item_owner_pvt_w.rosetta_table_copy_out_p8(ddx_error_tbl, p12_a0

945: p10_a65 := ddp_item_rec_out.attribute14;
946: p10_a66 := ddp_item_rec_out.attribute15;
947:
948:
949: ams_item_owner_pvt_w.rosetta_table_copy_out_p8(ddx_error_tbl, p12_a0
950: , p12_a1
951: , p12_a2
952: , p12_a3
953: , p12_a4

Line 1046: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;

1042: , p4_a66 VARCHAR2 := fnd_api.g_miss_char
1043: )
1044:
1045: as
1046: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
1047: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
1048: ddindx binary_integer; indx binary_integer;
1049: begin
1050:

Line 1047: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;

1043: )
1044:
1045: as
1046: ddp_item_owner_rec ams_item_owner_pvt.item_owner_rec_type;
1047: ddp_item_rec_in ams_item_owner_pvt.item_rec_type;
1048: ddindx binary_integer; indx binary_integer;
1049: begin
1050:
1051: -- copy data to the local IN or IN-OUT args, if any

Line 1139: ams_item_owner_pvt.validate_item_owner(p_api_version_number,

1135:
1136:
1137:
1138: -- here's the delegated call to the old PL/SQL routine
1139: ams_item_owner_pvt.validate_item_owner(p_api_version_number,
1140: p_init_msg_list,
1141: p_validation_level,
1142: ddp_item_owner_rec,
1143: ddp_item_rec_in,

Line 1158: end ams_item_owner_pvt_w;

1154:
1155:
1156: end;
1157:
1158: end ams_item_owner_pvt_w;