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.OZF_THRESHOLD_RULE_PVT_W dependencies on OZF_THRESHOLD_RULE_PVT

Line 1: package body ozf_threshold_rule_pvt_w as

1: package body ozf_threshold_rule_pvt_w as
2: /* $Header: ozfwtrub.pls 120.0.12020000.2 2012/07/25 06:49:54 sariff 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 ozf_threshold_rule_pvt.threshold_rule_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 ozf_threshold_rule_pvt.threshold_rule_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 129: procedure rosetta_table_copy_out_p3(t ozf_threshold_rule_pvt.threshold_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p3;
129: procedure rosetta_table_copy_out_p3(t ozf_threshold_rule_pvt.threshold_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_DATE_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_DATE_TABLE

Line 447: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

443: , x_threshold_rule_id out nocopy NUMBER
444: )
445:
446: as
447: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:
451: -- copy data to the local IN or IN-OUT args, if any

Line 510: ozf_threshold_rule_pvt.create_threshold_rule(p_api_version_number,

506: ddp_threshold_rule_rec.alert_type := p7_a47;
507:
508:
509: -- here's the delegated call to the old PL/SQL routine
510: ozf_threshold_rule_pvt.create_threshold_rule(p_api_version_number,
511: p_init_msg_list,
512: p_commit,
513: p_validation_level,
514: x_return_status,

Line 590: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

586: , x_object_version_number out nocopy NUMBER
587: )
588:
589: as
590: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
591: ddindx binary_integer; indx binary_integer;
592: begin
593:
594: -- copy data to the local IN or IN-OUT args, if any

Line 653: ozf_threshold_rule_pvt.update_threshold_rule(p_api_version_number,

649: ddp_threshold_rule_rec.alert_type := p7_a47;
650:
651:
652: -- here's the delegated call to the old PL/SQL routine
653: ozf_threshold_rule_pvt.update_threshold_rule(p_api_version_number,
654: p_init_msg_list,
655: p_commit,
656: p_validation_level,
657: x_return_status,

Line 731: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

727: , x_msg_data out nocopy VARCHAR2
728: )
729:
730: as
731: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
732: ddindx binary_integer; indx binary_integer;
733: begin
734:
735: -- copy data to the local IN or IN-OUT args, if any

Line 792: ozf_threshold_rule_pvt.validate_threshold_rule(p_api_version_number,

788:
789:
790:
791: -- here's the delegated call to the old PL/SQL routine
792: ozf_threshold_rule_pvt.validate_threshold_rule(p_api_version_number,
793: p_init_msg_list,
794: p_validation_level,
795: ddp_threshold_rule_rec,
796: x_return_status,

Line 862: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

858: , x_return_status out nocopy VARCHAR2
859: )
860:
861: as
862: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
863: ddindx binary_integer; indx binary_integer;
864: begin
865:
866: -- copy data to the local IN or IN-OUT args, if any

Line 919: ozf_threshold_rule_pvt.check_threshold_rule_items(ddp_threshold_rule_rec,

915:
916:
917:
918: -- here's the delegated call to the old PL/SQL routine
919: ozf_threshold_rule_pvt.check_threshold_rule_items(ddp_threshold_rule_rec,
920: p_validation_mode,
921: x_return_status);
922:
923: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 984: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

980: , p5_a47 VARCHAR2
981: )
982:
983: as
984: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
985: ddindx binary_integer; indx binary_integer;
986: begin
987:
988: -- copy data to the local IN or IN-OUT args, if any

Line 1044: ozf_threshold_rule_pvt.validate_threshold_rule_rec(p_api_version_number,

1040: ddp_threshold_rule_rec.comparison_type := p5_a46;
1041: ddp_threshold_rule_rec.alert_type := p5_a47;
1042:
1043: -- here's the delegated call to the old PL/SQL routine
1044: ozf_threshold_rule_pvt.validate_threshold_rule_rec(p_api_version_number,
1045: p_init_msg_list,
1046: x_return_status,
1047: x_msg_count,
1048: x_msg_data,

Line 1158: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

1154: , p1_a47 out nocopy VARCHAR2
1155: )
1156:
1157: as
1158: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
1159: ddx_complete_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
1160: ddindx binary_integer; indx binary_integer;
1161: begin
1162:

Line 1159: ddx_complete_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;

1155: )
1156:
1157: as
1158: ddp_threshold_rule_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
1159: ddx_complete_rec ozf_threshold_rule_pvt.threshold_rule_rec_type;
1160: ddindx binary_integer; indx binary_integer;
1161: begin
1162:
1163: -- copy data to the local IN or IN-OUT args, if any

Line 1215: ozf_threshold_rule_pvt.complete_threshold_rule_rec(ddp_threshold_rule_rec,

1211: ddp_threshold_rule_rec.alert_type := p0_a47;
1212:
1213:
1214: -- here's the delegated call to the old PL/SQL routine
1215: ozf_threshold_rule_pvt.complete_threshold_rule_rec(ddp_threshold_rule_rec,
1216: ddx_complete_rec);
1217:
1218: -- copy data back from the local variables to OUT or IN-OUT args, if any
1219:

Line 1270: end ozf_threshold_rule_pvt_w;

1266: p1_a46 := ddx_complete_rec.comparison_type;
1267: p1_a47 := ddx_complete_rec.alert_type;
1268: end;
1269:
1270: end ozf_threshold_rule_pvt_w;