DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT_W dependencies on AHL_UMP_UNITMAINT_PVT

Line 1: package body ahl_ump_unitmaint_pvt_w as

1: package body ahl_ump_unitmaint_pvt_w as
2: /* $Header: AHLVUMWB.pls 120.1 2005/08/17 09:02:53 pbarman 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_p3(t out nocopy ahl_ump_unitmaint_pvt.unit_effectivity_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_ump_unitmaint_pvt.unit_effectivity_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 125: procedure rosetta_table_copy_out_p3(t ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

121: end loop;
122: end if;
123: end if;
124: end rosetta_table_copy_in_p3;
125: procedure rosetta_table_copy_out_p3(t ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_DATE_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_DATE_TABLE

Line 374: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 JTF_NUMBER_TABLE

370: end if;
371: end if;
372: end rosetta_table_copy_out_p3;
373:
374: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 JTF_NUMBER_TABLE
375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_DATE_TABLE
377: , a3 JTF_NUMBER_TABLE
378: , a4 JTF_DATE_TABLE

Line 449: procedure rosetta_table_copy_out_p4(t ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

445: end loop;
446: end if;
447: end if;
448: end rosetta_table_copy_in_p4;
449: procedure rosetta_table_copy_out_p4(t ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
450: , a1 out nocopy JTF_NUMBER_TABLE
451: , a2 out nocopy JTF_DATE_TABLE
452: , a3 out nocopy JTF_NUMBER_TABLE
453: , a4 out nocopy JTF_DATE_TABLE

Line 613: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 JTF_NUMBER_TABLE

609: end if;
610: end if;
611: end rosetta_table_copy_out_p4;
612:
613: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 JTF_NUMBER_TABLE
614: , a1 JTF_NUMBER_TABLE
615: , a2 JTF_DATE_TABLE
616: , a3 JTF_NUMBER_TABLE
617: , a4 JTF_DATE_TABLE

Line 686: procedure rosetta_table_copy_out_p5(t ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

682: end loop;
683: end if;
684: end if;
685: end rosetta_table_copy_in_p5;
686: procedure rosetta_table_copy_out_p5(t ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
687: , a1 out nocopy JTF_NUMBER_TABLE
688: , a2 out nocopy JTF_DATE_TABLE
689: , a3 out nocopy JTF_NUMBER_TABLE
690: , a4 out nocopy JTF_DATE_TABLE

Line 960: ddp_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;

956: , x_msg_data out nocopy VARCHAR2
957: )
958:
959: as
960: ddp_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
961: ddp_x_unit_threshold_tbl ahl_ump_unitmaint_pvt.unit_threshold_tbl_type;
962: ddp_x_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
963: ddindx binary_integer; indx binary_integer;
964: begin

Line 961: ddp_x_unit_threshold_tbl ahl_ump_unitmaint_pvt.unit_threshold_tbl_type;

957: )
958:
959: as
960: ddp_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
961: ddp_x_unit_threshold_tbl ahl_ump_unitmaint_pvt.unit_threshold_tbl_type;
962: ddp_x_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
963: ddindx binary_integer; indx binary_integer;
964: begin
965:

Line 962: ddp_x_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;

958:
959: as
960: ddp_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
961: ddp_x_unit_threshold_tbl ahl_ump_unitmaint_pvt.unit_threshold_tbl_type;
962: ddp_x_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
963: ddindx binary_integer; indx binary_integer;
964: begin
965:
966: -- copy data to the local IN or IN-OUT args, if any

Line 973: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p3(ddp_unit_effectivity_tbl, p6_a0

969:
970:
971:
972:
973: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p3(ddp_unit_effectivity_tbl, p6_a0
974: , p6_a1
975: , p6_a2
976: , p6_a3
977: , p6_a4

Line 1021: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p4(ddp_x_unit_threshold_tbl, p7_a0

1017: , p6_a44
1018: , p6_a45
1019: );
1020:
1021: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p4(ddp_x_unit_threshold_tbl, p7_a0
1022: , p7_a1
1023: , p7_a2
1024: , p7_a3
1025: , p7_a4

Line 1052: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p5(ddp_x_unit_accomplish_tbl, p8_a0

1048: , p7_a27
1049: , p7_a28
1050: );
1051:
1052: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_in_p5(ddp_x_unit_accomplish_tbl, p8_a0
1053: , p8_a1
1054: , p8_a2
1055: , p8_a3
1056: , p8_a4

Line 1086: ahl_ump_unitmaint_pvt.capture_mr_updates(p_api_version,

1082:
1083:
1084:
1085: -- here's the delegated call to the old PL/SQL routine
1086: ahl_ump_unitmaint_pvt.capture_mr_updates(p_api_version,
1087: p_init_msg_list,
1088: p_commit,
1089: p_validation_level,
1090: p_default,

Line 1107: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_out_p4(ddp_x_unit_threshold_tbl, p7_a0

1103:
1104:
1105:
1106:
1107: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_out_p4(ddp_x_unit_threshold_tbl, p7_a0
1108: , p7_a1
1109: , p7_a2
1110: , p7_a3
1111: , p7_a4

Line 1138: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_out_p5(ddp_x_unit_accomplish_tbl, p8_a0

1134: , p7_a27
1135: , p7_a28
1136: );
1137:
1138: ahl_ump_unitmaint_pvt_w.rosetta_table_copy_out_p5(ddp_x_unit_accomplish_tbl, p8_a0
1139: , p8_a1
1140: , p8_a2
1141: , p8_a3
1142: , p8_a4

Line 1172: end ahl_ump_unitmaint_pvt_w;

1168:
1169:
1170: end;
1171:
1172: end ahl_ump_unitmaint_pvt_w;