eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_APPROVALS_PVT_W dependencies on AHL_APPROVALS_PVT

Line 1: package body ahl_approvals_pvt_w as

1: package body ahl_approvals_pvt_w as
2: /* $Header: AHLWAPRB.pls 120.1 2006/05/02 07:21 sathapli 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, 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_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE

Line 331: ddp_x_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

327: , x_msg_data out nocopy VARCHAR2
328: )
329:
330: as
331: ddp_x_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
332: ddp_x_approvers_tbl ahl_approvals_pvt.approvers_tbl;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:

Line 332: ddp_x_approvers_tbl ahl_approvals_pvt.approvers_tbl;

328: )
329:
330: as
331: ddp_x_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
332: ddp_x_approvers_tbl ahl_approvals_pvt.approvers_tbl;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 379: ahl_approvals_pvt_w.rosetta_table_copy_in_p2(ddp_x_approvers_tbl, p5_a0

375: ddp_x_approval_rules_rec.last_updated_by := p4_a34;
376: ddp_x_approval_rules_rec.last_update_login := p4_a35;
377: ddp_x_approval_rules_rec.operation_flag := p4_a36;
378:
379: ahl_approvals_pvt_w.rosetta_table_copy_in_p2(ddp_x_approvers_tbl, p5_a0
380: , p5_a1
381: , p5_a2
382: , p5_a3
383: , p5_a4

Line 414: ahl_approvals_pvt.process_approvals(p_api_version,

410:
411:
412:
413: -- here's the delegated call to the old PL/SQL routine
414: ahl_approvals_pvt.process_approvals(p_api_version,
415: p_init_msg_list,
416: p_commit,
417: p_validation_level,
418: ddp_x_approval_rules_rec,

Line 467: ahl_approvals_pvt_w.rosetta_table_copy_out_p2(ddp_x_approvers_tbl, p5_a0

463: p4_a34 := ddp_x_approval_rules_rec.last_updated_by;
464: p4_a35 := ddp_x_approval_rules_rec.last_update_login;
465: p4_a36 := ddp_x_approval_rules_rec.operation_flag;
466:
467: ahl_approvals_pvt_w.rosetta_table_copy_out_p2(ddp_x_approvers_tbl, p5_a0
468: , p5_a1
469: , p5_a2
470: , p5_a3
471: , p5_a4

Line 550: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

546: , x_approval_rules_id out nocopy NUMBER
547: )
548:
549: as
550: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
551: ddindx binary_integer; indx binary_integer;
552: begin
553:
554: -- copy data to the local IN or IN-OUT args, if any

Line 602: ahl_approvals_pvt.create_approval_rules(p_api_version,

598: ddp_approval_rules_rec.operation_flag := p7_a36;
599:
600:
601: -- here's the delegated call to the old PL/SQL routine
602: ahl_approvals_pvt.create_approval_rules(p_api_version,
603: p_init_msg_list,
604: p_commit,
605: p_validation_level,
606: x_return_status,

Line 670: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

666: , p7_a36 VARCHAR2
667: )
668:
669: as
670: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
671: ddindx binary_integer; indx binary_integer;
672: begin
673:
674: -- copy data to the local IN or IN-OUT args, if any

Line 721: ahl_approvals_pvt.update_approval_rules(p_api_version,

717: ddp_approval_rules_rec.last_update_login := p7_a35;
718: ddp_approval_rules_rec.operation_flag := p7_a36;
719:
720: -- here's the delegated call to the old PL/SQL routine
721: ahl_approvals_pvt.update_approval_rules(p_api_version,
722: p_init_msg_list,
723: p_commit,
724: p_validation_level,
725: x_return_status,

Line 787: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

783: , p7_a36 VARCHAR2
784: )
785:
786: as
787: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
788: ddindx binary_integer; indx binary_integer;
789: begin
790:
791: -- copy data to the local IN or IN-OUT args, if any

Line 838: ahl_approvals_pvt.validate_approval_rules(p_api_version,

834: ddp_approval_rules_rec.last_update_login := p7_a35;
835: ddp_approval_rules_rec.operation_flag := p7_a36;
836:
837: -- here's the delegated call to the old PL/SQL routine
838: ahl_approvals_pvt.validate_approval_rules(p_api_version,
839: p_init_msg_list,
840: p_commit,
841: p_validation_level,
842: x_return_status,

Line 899: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

895: , x_return_status out nocopy VARCHAR2
896: )
897:
898: as
899: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
900: ddindx binary_integer; indx binary_integer;
901: begin
902:
903: -- copy data to the local IN or IN-OUT args, if any

Line 945: ahl_approvals_pvt.check_approval_rules_items(ddp_approval_rules_rec,

941:
942:
943:
944: -- here's the delegated call to the old PL/SQL routine
945: ahl_approvals_pvt.check_approval_rules_items(ddp_approval_rules_rec,
946: p_validation_mode,
947: x_return_status);
948:
949: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1032: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

1028: , x_return_status out nocopy VARCHAR2
1029: )
1030:
1031: as
1032: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
1033: ddp_complete_rec ahl_approvals_pvt.approval_rules_rec_type;
1034: ddindx binary_integer; indx binary_integer;
1035: begin
1036:

Line 1033: ddp_complete_rec ahl_approvals_pvt.approval_rules_rec_type;

1029: )
1030:
1031: as
1032: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
1033: ddp_complete_rec ahl_approvals_pvt.approval_rules_rec_type;
1034: ddindx binary_integer; indx binary_integer;
1035: begin
1036:
1037: -- copy data to the local IN or IN-OUT args, if any

Line 1116: ahl_approvals_pvt.check_approval_rules_record(ddp_approval_rules_rec,

1112: ddp_complete_rec.operation_flag := p1_a36;
1113:
1114:
1115: -- here's the delegated call to the old PL/SQL routine
1116: ahl_approvals_pvt.check_approval_rules_record(ddp_approval_rules_rec,
1117: ddp_complete_rec,
1118: x_return_status);
1119:
1120: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1202: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

1198: , p1_a36 out nocopy VARCHAR2
1199: )
1200:
1201: as
1202: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
1203: ddx_complete_rec ahl_approvals_pvt.approval_rules_rec_type;
1204: ddindx binary_integer; indx binary_integer;
1205: begin
1206:

Line 1203: ddx_complete_rec ahl_approvals_pvt.approval_rules_rec_type;

1199: )
1200:
1201: as
1202: ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;
1203: ddx_complete_rec ahl_approvals_pvt.approval_rules_rec_type;
1204: ddindx binary_integer; indx binary_integer;
1205: begin
1206:
1207: -- copy data to the local IN or IN-OUT args, if any

Line 1248: ahl_approvals_pvt.complete_approval_rules_rec(ddp_approval_rules_rec,

1244: ddp_approval_rules_rec.operation_flag := p0_a36;
1245:
1246:
1247: -- here's the delegated call to the old PL/SQL routine
1248: ahl_approvals_pvt.complete_approval_rules_rec(ddp_approval_rules_rec,
1249: ddx_complete_rec);
1250:
1251: -- copy data back from the local variables to OUT or IN-OUT args, if any
1252:

Line 1332: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

1328: , x_approval_approver_id out nocopy NUMBER
1329: )
1330:
1331: as
1332: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1333: ddindx binary_integer; indx binary_integer;
1334: begin
1335:
1336: -- copy data to the local IN or IN-OUT args, if any

Line 1376: ahl_approvals_pvt.create_approvers(p_api_version,

1372: ddp_approvers_rec.operation_flag := p7_a28;
1373:
1374:
1375: -- here's the delegated call to the old PL/SQL routine
1376: ahl_approvals_pvt.create_approvers(p_api_version,
1377: p_init_msg_list,
1378: p_commit,
1379: p_validation_level,
1380: x_return_status,

Line 1436: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

1432: , x_msg_data out nocopy VARCHAR2
1433: )
1434:
1435: as
1436: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1437: ddindx binary_integer; indx binary_integer;
1438: begin
1439:
1440: -- copy data to the local IN or IN-OUT args, if any

Line 1479: ahl_approvals_pvt.update_approvers(p_api_version,

1475:
1476:
1477:
1478: -- here's the delegated call to the old PL/SQL routine
1479: ahl_approvals_pvt.update_approvers(p_api_version,
1480: p_init_msg_list,
1481: p_commit,
1482: p_validation_level,
1483: ddp_approvers_rec,

Line 1537: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

1533: , p7_a28 VARCHAR2
1534: )
1535:
1536: as
1537: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1538: ddindx binary_integer; indx binary_integer;
1539: begin
1540:
1541: -- copy data to the local IN or IN-OUT args, if any

Line 1580: ahl_approvals_pvt.validate_approvers(p_api_version,

1576: ddp_approvers_rec.attribute15 := p7_a27;
1577: ddp_approvers_rec.operation_flag := p7_a28;
1578:
1579: -- here's the delegated call to the old PL/SQL routine
1580: ahl_approvals_pvt.validate_approvers(p_api_version,
1581: p_init_msg_list,
1582: p_commit,
1583: p_validation_level,
1584: x_return_status,

Line 1633: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

1629: , x_return_status out nocopy VARCHAR2
1630: )
1631:
1632: as
1633: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1634: ddindx binary_integer; indx binary_integer;
1635: begin
1636:
1637: -- copy data to the local IN or IN-OUT args, if any

Line 1671: ahl_approvals_pvt.check_approvers_items(p_validation_mode,

1667: ddp_approvers_rec.operation_flag := p1_a28;
1668:
1669:
1670: -- here's the delegated call to the old PL/SQL routine
1671: ahl_approvals_pvt.check_approvers_items(p_validation_mode,
1672: ddp_approvers_rec,
1673: x_return_status);
1674:
1675: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1741: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

1737: , p1_a28 out nocopy VARCHAR2
1738: )
1739:
1740: as
1741: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1742: ddx_complete_rec ahl_approvals_pvt.approvers_rec_type;
1743: ddindx binary_integer; indx binary_integer;
1744: begin
1745:

Line 1742: ddx_complete_rec ahl_approvals_pvt.approvers_rec_type;

1738: )
1739:
1740: as
1741: ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;
1742: ddx_complete_rec ahl_approvals_pvt.approvers_rec_type;
1743: ddindx binary_integer; indx binary_integer;
1744: begin
1745:
1746: -- copy data to the local IN or IN-OUT args, if any

Line 1779: ahl_approvals_pvt.complete_approvers_rec(ddp_approvers_rec,

1775: ddp_approvers_rec.operation_flag := p0_a28;
1776:
1777:
1778: -- here's the delegated call to the old PL/SQL routine
1779: ahl_approvals_pvt.complete_approvers_rec(ddp_approvers_rec,
1780: ddx_complete_rec);
1781:
1782: -- copy data back from the local variables to OUT or IN-OUT args, if any
1783:

Line 1815: end ahl_approvals_pvt_w;

1811: p1_a27 := ddx_complete_rec.attribute15;
1812: p1_a28 := ddx_complete_rec.operation_flag;
1813: end;
1814:
1815: end ahl_approvals_pvt_w;