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_MC_RULE_PVT_W dependencies on AHL_MC_RULE_PVT

Line 1: package body ahl_mc_rule_pvt_w as

1: package body ahl_mc_rule_pvt_w as
2: /* $Header: AHLWMCRB.pls 120.1.12010000.2 2008/11/26 14:12:38 sathapli 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_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_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_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE

Line 339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE

335: end if;
336: end if;
337: end rosetta_table_copy_out_p3;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE

Line 430: procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

426: end loop;
427: end if;
428: end if;
429: end rosetta_table_copy_in_p4;
430: procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
431: , a1 out nocopy JTF_NUMBER_TABLE
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE

Line 634: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE

630: end if;
631: end if;
632: end rosetta_table_copy_out_p4;
633:
634: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
635: , a1 JTF_NUMBER_TABLE
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE

Line 717: procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

713: end loop;
714: end if;
715: end if;
716: end rosetta_table_copy_in_p5;
717: procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
718: , a1 out nocopy JTF_NUMBER_TABLE
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE

Line 953: ddx_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;

949: , p8_a40 out nocopy JTF_VARCHAR2_TABLE_200
950: )
951:
952: as
953: ddx_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;
954: ddindx binary_integer; indx binary_integer;
955: begin
956:
957: -- copy data to the local IN or IN-OUT args, if any

Line 968: ahl_mc_rule_pvt.load_rule(p_api_version,

964:
965:
966:
967: -- here's the delegated call to the old PL/SQL routine
968: ahl_mc_rule_pvt.load_rule(p_api_version,
969: p_init_msg_list,
970: p_commit,
971: p_validation_level,
972: x_return_status,

Line 987: ahl_mc_rule_pvt_w.rosetta_table_copy_out_p3(ddx_rule_stmt_tbl, p8_a0

983:
984:
985:
986:
987: ahl_mc_rule_pvt_w.rosetta_table_copy_out_p3(ddx_rule_stmt_tbl, p8_a0
988: , p8_a1
989: , p8_a2
990: , p8_a3
991: , p8_a4

Line 1116: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;

1112: , p9_a32 in out nocopy VARCHAR2
1113: )
1114:
1115: as
1116: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;
1117: ddp_x_rule_rec ahl_mc_rule_pvt.rule_rec_type;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:

Line 1117: ddp_x_rule_rec ahl_mc_rule_pvt.rule_rec_type;

1113: )
1114:
1115: as
1116: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;
1117: ddp_x_rule_rec ahl_mc_rule_pvt.rule_rec_type;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:
1121: -- copy data to the local IN or IN-OUT args, if any

Line 1130: ahl_mc_rule_pvt_w.rosetta_table_copy_in_p3(ddp_rule_stmt_tbl, p8_a0

1126:
1127:
1128:
1129:
1130: ahl_mc_rule_pvt_w.rosetta_table_copy_in_p3(ddp_rule_stmt_tbl, p8_a0
1131: , p8_a1
1132: , p8_a2
1133: , p8_a3
1134: , p8_a4

Line 1208: ahl_mc_rule_pvt.insert_rule(p_api_version,

1204: ddp_x_rule_rec.attribute15 := p9_a31;
1205: ddp_x_rule_rec.operation_flag := p9_a32;
1206:
1207: -- here's the delegated call to the old PL/SQL routine
1208: ahl_mc_rule_pvt.insert_rule(p_api_version,
1209: p_init_msg_list,
1210: p_commit,
1211: p_validation_level,
1212: x_return_status,

Line 1349: ddp_rule_rec ahl_mc_rule_pvt.rule_rec_type;

1345: , p9_a40 JTF_VARCHAR2_TABLE_200
1346: )
1347:
1348: as
1349: ddp_rule_rec ahl_mc_rule_pvt.rule_rec_type;
1350: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;
1351: ddindx binary_integer; indx binary_integer;
1352: begin
1353:

Line 1350: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;

1346: )
1347:
1348: as
1349: ddp_rule_rec ahl_mc_rule_pvt.rule_rec_type;
1350: ddp_rule_stmt_tbl ahl_mc_rule_pvt.ui_rule_stmt_tbl_type;
1351: ddindx binary_integer; indx binary_integer;
1352: begin
1353:
1354: -- copy data to the local IN or IN-OUT args, if any

Line 1397: ahl_mc_rule_pvt_w.rosetta_table_copy_in_p3(ddp_rule_stmt_tbl, p9_a0

1393: ddp_rule_rec.attribute14 := p8_a30;
1394: ddp_rule_rec.attribute15 := p8_a31;
1395: ddp_rule_rec.operation_flag := p8_a32;
1396:
1397: ahl_mc_rule_pvt_w.rosetta_table_copy_in_p3(ddp_rule_stmt_tbl, p9_a0
1398: , p9_a1
1399: , p9_a2
1400: , p9_a3
1401: , p9_a4

Line 1441: ahl_mc_rule_pvt.update_rule(p_api_version,

1437: , p9_a40
1438: );
1439:
1440: -- here's the delegated call to the old PL/SQL routine
1441: ahl_mc_rule_pvt.update_rule(p_api_version,
1442: p_init_msg_list,
1443: p_commit,
1444: p_validation_level,
1445: x_return_status,

Line 1507: ddp_rule_rec ahl_mc_rule_pvt.rule_rec_type;

1503: , p7_a32 VARCHAR2
1504: )
1505:
1506: as
1507: ddp_rule_rec ahl_mc_rule_pvt.rule_rec_type;
1508: ddindx binary_integer; indx binary_integer;
1509: begin
1510:
1511: -- copy data to the local IN or IN-OUT args, if any

Line 1554: ahl_mc_rule_pvt.delete_rule(p_api_version,

1550: ddp_rule_rec.attribute15 := p7_a31;
1551: ddp_rule_rec.operation_flag := p7_a32;
1552:
1553: -- here's the delegated call to the old PL/SQL routine
1554: ahl_mc_rule_pvt.delete_rule(p_api_version,
1555: p_init_msg_list,
1556: p_commit,
1557: p_validation_level,
1558: x_return_status,

Line 1618: ddx_rule_tbl ahl_mc_rule_pvt.rule_tbl_type;

1614: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
1615: )
1616:
1617: as
1618: ddx_rule_tbl ahl_mc_rule_pvt.rule_tbl_type;
1619: ddindx binary_integer; indx binary_integer;
1620: begin
1621:
1622: -- copy data to the local IN or IN-OUT args, if any

Line 1634: ahl_mc_rule_pvt.get_rules_for_position(p_api_version,

1630:
1631:
1632:
1633: -- here's the delegated call to the old PL/SQL routine
1634: ahl_mc_rule_pvt.get_rules_for_position(p_api_version,
1635: p_init_msg_list,
1636: p_commit,
1637: p_validation_level,
1638: x_return_status,

Line 1655: ahl_mc_rule_pvt_w.rosetta_table_copy_out_p5(ddx_rule_tbl, p9_a0

1651:
1652:
1653:
1654:
1655: ahl_mc_rule_pvt_w.rosetta_table_copy_out_p5(ddx_rule_tbl, p9_a0
1656: , p9_a1
1657: , p9_a2
1658: , p9_a3
1659: , p9_a4

Line 1691: end ahl_mc_rule_pvt_w;

1687: , p9_a32
1688: );
1689: end;
1690:
1691: end ahl_mc_rule_pvt_w;