DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT_W dependencies on AHL_PRD_MTLTXN_PVT

Line 1: package body ahl_prd_mtltxn_pvt_w as

1: package body ahl_prd_mtltxn_pvt_w as
2: /* $Header: AHLWMTXB.pls 120.4.12010000.3 2008/11/19 06:09:46 jkjain 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_p5(t out nocopy ahl_prd_mtltxn_pvt.ahl_mtltxn_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_p5(t out nocopy ahl_prd_mtltxn_pvt.ahl_mtltxn_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 155: procedure rosetta_table_copy_out_p5(t ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

151: end loop;
152: end if;
153: end if;
154: end rosetta_table_copy_in_p5;
155: procedure rosetta_table_copy_out_p5(t ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_NUMBER_TABLE
157: , a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , a3 out nocopy JTF_VARCHAR2_TABLE_100
159: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 479: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 JTF_NUMBER_TABLE) as

475: end if;
476: end if;
477: end rosetta_table_copy_out_p5;
478:
479: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 JTF_NUMBER_TABLE) as
480: ddindx binary_integer; indx binary_integer;
481: begin
482: if a0 is not null and a0.count > 0 then
483: if a0.count > 0 then

Line 497: procedure rosetta_table_copy_out_p6(t ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

493: end loop;
494: end if;
495: end if;
496: end rosetta_table_copy_in_p6;
497: procedure rosetta_table_copy_out_p6(t ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();

Line 594: ddp_x_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;

590: , x_msg_data out nocopy VARCHAR2
591: )
592:
593: as
594: ddp_x_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:
598: -- copy data to the local IN or IN-OUT args, if any

Line 606: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddp_x_ahl_mtltxn_tbl, p7_a0

602:
603:
604:
605:
606: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddp_x_ahl_mtltxn_tbl, p7_a0
607: , p7_a1
608: , p7_a2
609: , p7_a3
610: , p7_a4

Line 673: ahl_prd_mtltxn_pvt.perform_mtl_txn(p_api_version,

669:
670:
671:
672: -- here's the delegated call to the old PL/SQL routine
673: ahl_prd_mtltxn_pvt.perform_mtl_txn(p_api_version,
674: p_init_msg_list,
675: p_commit,
676: p_validation_level,
677: p_default,

Line 693: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddp_x_ahl_mtltxn_tbl, p7_a0

689:
690:
691:
692:
693: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddp_x_ahl_mtltxn_tbl, p7_a0
694: , p7_a1
695: , p7_a2
696: , p7_a3
697: , p7_a4

Line 829: ddp_x_ahl_mtltxn_rec ahl_prd_mtltxn_pvt.ahl_mtltxn_rec_type;

825: , x_msg_data out nocopy VARCHAR2
826: )
827:
828: as
829: ddp_x_ahl_mtltxn_rec ahl_prd_mtltxn_pvt.ahl_mtltxn_rec_type;
830: ddindx binary_integer; indx binary_integer;
831: begin
832:
833: -- copy data to the local IN or IN-OUT args, if any

Line 902: ahl_prd_mtltxn_pvt.validate_txn_rec(ddp_x_ahl_mtltxn_rec,

898:
899:
900:
901: -- here's the delegated call to the old PL/SQL routine
902: ahl_prd_mtltxn_pvt.validate_txn_rec(ddp_x_ahl_mtltxn_rec,
903: x_item_instance_id,
904: x_eam_item_type_id,
905: x_return_status,
906: x_msg_count,

Line 1062: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;

1058: , p10_a60 in out nocopy JTF_VARCHAR2_TABLE_200
1059: )
1060:
1061: as
1062: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;
1063: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
1064: ddindx binary_integer; indx binary_integer;
1065: begin
1066:

Line 1063: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;

1059: )
1060:
1061: as
1062: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;
1063: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
1064: ddindx binary_integer; indx binary_integer;
1065: begin
1066:
1067: -- copy data to the local IN or IN-OUT args, if any

Line 1089: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddx_ahl_mtltxn_tbl, p10_a0

1085: ddp_prd_mtltxn_criteria_rec.department_name := p9_a8;
1086: ddp_prd_mtltxn_criteria_rec.disposition_name := p9_a9;
1087: ddp_prd_mtltxn_criteria_rec.transaction_type := p9_a10;
1088:
1089: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddx_ahl_mtltxn_tbl, p10_a0
1090: , p10_a1
1091: , p10_a2
1092: , p10_a3
1093: , p10_a4

Line 1153: ahl_prd_mtltxn_pvt.get_mtl_trans_returns(p_api_version,

1149: , p10_a60
1150: );
1151:
1152: -- here's the delegated call to the old PL/SQL routine
1153: ahl_prd_mtltxn_pvt.get_mtl_trans_returns(p_api_version,
1154: p_init_msg_list,
1155: p_commit,
1156: p_validation_level,
1157: p_default,

Line 1176: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddx_ahl_mtltxn_tbl, p10_a0

1172:
1173:
1174:
1175:
1176: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddx_ahl_mtltxn_tbl, p10_a0
1177: , p10_a1
1178: , p10_a2
1179: , p10_a3
1180: , p10_a4

Line 1240: end ahl_prd_mtltxn_pvt_w;

1236: , p10_a60
1237: );
1238: end;
1239:
1240: end ahl_prd_mtltxn_pvt_w;