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.8.12020000.2 2012/12/13 06:25:22 shnatu 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 159: procedure rosetta_table_copy_out_p5(t ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

155: end loop;
156: end if;
157: end if;
158: end rosetta_table_copy_in_p5;
159: procedure rosetta_table_copy_out_p5(t ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_VARCHAR2_TABLE_100
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

489: end if;
490: end if;
491: end rosetta_table_copy_out_p5;
492:
493: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 JTF_NUMBER_TABLE) as
494: ddindx binary_integer; indx binary_integer;
495: begin
496: if a0 is not null and a0.count > 0 then
497: if a0.count > 0 then

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

507: end loop;
508: end if;
509: end if;
510: end rosetta_table_copy_in_p6;
511: procedure rosetta_table_copy_out_p6(t ahl_prd_mtltxn_pvt.ahl_mtl_txn_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
512: ddindx binary_integer; indx binary_integer;
513: begin
514: if t is null or t.count = 0 then
515: a0 := JTF_NUMBER_TABLE();

Line 610: ddp_x_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;

606: , x_msg_data out nocopy VARCHAR2
607: )
608:
609: as
610: ddp_x_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
611: ddindx binary_integer; indx binary_integer;
612: begin
613:
614: -- copy data to the local IN or IN-OUT args, if any

Line 622: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddp_x_ahl_mtltxn_tbl, p7_a0

618:
619:
620:
621:
622: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddp_x_ahl_mtltxn_tbl, p7_a0
623: , p7_a1
624: , p7_a2
625: , p7_a3
626: , p7_a4

Line 691: ahl_prd_mtltxn_pvt.perform_mtl_txn(p_api_version,

687:
688:
689:
690: -- here's the delegated call to the old PL/SQL routine
691: ahl_prd_mtltxn_pvt.perform_mtl_txn(p_api_version,
692: p_init_msg_list,
693: p_commit,
694: p_validation_level,
695: p_default,

Line 711: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddp_x_ahl_mtltxn_tbl, p7_a0

707:
708:
709:
710:
711: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddp_x_ahl_mtltxn_tbl, p7_a0
712: , p7_a1
713: , p7_a2
714: , p7_a3
715: , p7_a4

Line 851: ddp_x_ahl_mtltxn_rec ahl_prd_mtltxn_pvt.ahl_mtltxn_rec_type;

847: , x_msg_data out nocopy VARCHAR2
848: )
849:
850: as
851: ddp_x_ahl_mtltxn_rec ahl_prd_mtltxn_pvt.ahl_mtltxn_rec_type;
852: ddindx binary_integer; indx binary_integer;
853: begin
854:
855: -- copy data to the local IN or IN-OUT args, if any

Line 926: ahl_prd_mtltxn_pvt.validate_txn_rec(ddp_x_ahl_mtltxn_rec,

922:
923:
924:
925: -- here's the delegated call to the old PL/SQL routine
926: ahl_prd_mtltxn_pvt.validate_txn_rec(ddp_x_ahl_mtltxn_rec,
927: x_item_instance_id,
928: x_eam_item_type_id,
929: x_return_status,
930: x_msg_count,

Line 1090: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;

1086: , p10_a62 in out nocopy JTF_VARCHAR2_TABLE_200
1087: )
1088:
1089: as
1090: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;
1091: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094:

Line 1091: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;

1087: )
1088:
1089: as
1090: ddp_prd_mtltxn_criteria_rec ahl_prd_mtltxn_pvt.prd_mtltxn_criteria_rec;
1091: ddx_ahl_mtltxn_tbl ahl_prd_mtltxn_pvt.ahl_mtltxn_tbl_type;
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094:
1095: -- copy data to the local IN or IN-OUT args, if any

Line 1117: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddx_ahl_mtltxn_tbl, p10_a0

1113: ddp_prd_mtltxn_criteria_rec.department_name := p9_a8;
1114: ddp_prd_mtltxn_criteria_rec.disposition_name := p9_a9;
1115: ddp_prd_mtltxn_criteria_rec.transaction_type := p9_a10;
1116:
1117: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_in_p5(ddx_ahl_mtltxn_tbl, p10_a0
1118: , p10_a1
1119: , p10_a2
1120: , p10_a3
1121: , p10_a4

Line 1183: ahl_prd_mtltxn_pvt.get_mtl_trans_returns(p_api_version,

1179: , p10_a62
1180: );
1181:
1182: -- here's the delegated call to the old PL/SQL routine
1183: ahl_prd_mtltxn_pvt.get_mtl_trans_returns(p_api_version,
1184: p_init_msg_list,
1185: p_commit,
1186: p_validation_level,
1187: p_default,

Line 1206: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddx_ahl_mtltxn_tbl, p10_a0

1202:
1203:
1204:
1205:
1206: ahl_prd_mtltxn_pvt_w.rosetta_table_copy_out_p5(ddx_ahl_mtltxn_tbl, p10_a0
1207: , p10_a1
1208: , p10_a2
1209: , p10_a3
1210: , p10_a4

Line 1272: end ahl_prd_mtltxn_pvt_w;

1268: , p10_a62
1269: );
1270: end;
1271:
1272: end ahl_prd_mtltxn_pvt_w;