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_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_TEMP_UNIT_EFFECTIVITIES

Line 13: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

9: -- Declare Local Procedures --
10: ------------------------------
11:
12: -- To create ahl_unit_effectivities record.
13: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
14:
15:
16: -- To update ahl_unit_effectivities record.
17: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

Line 17: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

13: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
14:
15:
16: -- To update ahl_unit_effectivities record.
17: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
18: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
19:
20: -- To create decendent records and build relationships if the MR is a group MR.
21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

Line 21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);

17: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
18: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
19:
20: -- To create decendent records and build relationships if the MR is a group MR.
21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
22:
23: -- To update decendent records and update relationships if the MR is a group MR.
24: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
25: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);

Line 24: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

20: -- To create decendent records and build relationships if the MR is a group MR.
21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
22:
23: -- To update decendent records and update relationships if the MR is a group MR.
24: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
25: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
26:
27: -- Process deferral and SR records.
28: -- Added for 11.5.10.

Line 40: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)

36: ------------------------------
37: -- Define Procedures --
38: ------------------------------
39:
40: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
42:
43: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
44:

Line 70: FROM ahl_temp_unit_effectivities

66: program_mr_header_id,
67: earliest_due_date,
68: latest_due_date,
69: counter_id
70: FROM ahl_temp_unit_effectivities
71: WHERE MR_header_id = nvl(orig_mr_header_id, mr_header_id) AND
72: csi_item_instance_id = nvl(orig_csi_item_instance_id,csi_item_instance_id)
73: ORDER by forecast_sequence ASC
74: FOR UPDATE OF unit_effectivity_id;

Line 80: FROM ahl_temp_unit_effectivities

76: -- Cursor for getting all temp unit effectivities that have preceding MRs.
77: CURSOR dependent_mr_csr IS
78: SELECT preceding_mr_header_id, preceding_csi_item_instance_id,
79: preceding_forecast_seq, unit_effectivity_id
80: FROM ahl_temp_unit_effectivities
81: WHERE preceding_mr_header_id IS NOT NULL AND
82: preceding_csi_item_instance_id IS NOT NULL AND
83: preceding_forecast_seq IS NOT NULL;
84:

Line 90: FROM ahl_temp_unit_effectivities

86: CURSOR preceding_mr_csr (p_preceding_mr_header_id IN NUMBER,
87: p_preceding_item_instance IN NUMBER,
88: p_preceding_forecast_seq IN NUMBER) IS
89: SELECT unit_effectivity_id
90: FROM ahl_temp_unit_effectivities
91: WHERE mr_header_id = p_preceding_mr_header_id AND
92: csi_item_instance_id = p_preceding_item_instance AND
93: forecast_sequence = p_preceding_forecast_seq;
94:

Line 265: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;

261: l_start_time DATE;
262:
263: l_temp_individual_mr_rec temp_individual_mrs_csr%ROWTYPE;
264:
265: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
266: l_mr_rec ahl_unit_effectivities_app_v%ROWTYPE;
267:
268: l_temp_mr_found BOOLEAN;
269: l_mr_found BOOLEAN;

Line 447: UPDATE ahl_temp_unit_effectivities

443: ELSE
444:
445: create_record(l_temp_mr_rec);
446: -- update unit effectivity ID.
447: UPDATE ahl_temp_unit_effectivities
448: SET unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id
449: WHERE CURRENT OF temp_individual_mrs_csr;
450: END IF;
451: END IF;

Line 950: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)

946:
947: -----------------------------------------------------------------------------
948: -- To create ahl_unit_effectivities record.
949:
950: PROCEDURE create_record (p_x_temp_mr_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)
951:
952: IS
953: l_unit_effectivity_id NUMBER;
954: l_rowid VARCHAR2(30);

Line 1047: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

1043:
1044: -----------------------------------------------------------------------------
1045: -- To update ahl_unit_effectivities record.
1046:
1047: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1048: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1049: IS
1050:
1051: BEGIN

Line 1139: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)

1135:
1136: -----------------------------------------------------------------------------
1137: -- To create decendent records and build relationships if the MR is a group MR.
1138:
1139: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE)
1140:
1141: IS
1142: -- Read group elements.
1143: CURSOR ahl_temp_grp_csr(p_csi_item_instance_id IN NUMBER,

Line 1164: FROM ahl_temp_unit_effectivities

1160: message_code,
1161: earliest_due_date,
1162: latest_due_date,
1163: counter_id
1164: FROM ahl_temp_unit_effectivities
1165: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
1166: AND parent_mr_header_id = p_mr_header_id
1167: AND orig_csi_item_instance_id = p_csi_item_instance_id
1168: AND orig_mr_header_id = p_mr_header_id

Line 1186: FROM ahl_temp_unit_effectivities

1182: p_orig_csi_item_instance_id IN NUMBER,
1183: p_orig_mr_header_id IN NUMBER,
1184: p_forecast_sequence IN NUMBER) IS
1185: SELECT unit_effectivity_id
1186: FROM ahl_temp_unit_effectivities
1187: WHERE csi_item_instance_id = p_parent_csi_item_instance_id
1188: AND MR_header_id = p_parent_mr_header_id
1189: AND orig_csi_item_instance_id = p_orig_csi_item_instance_id
1190: AND orig_mr_header_id = p_orig_mr_header_id

Line 1201: l_temp_child_rec ahl_temp_unit_effectivities%ROWTYPE;

1197: l_orig_mr_header_id NUMBER;
1198:
1199: l_parent_ue_id NUMBER;
1200:
1201: l_temp_child_rec ahl_temp_unit_effectivities%ROWTYPE;
1202:
1203: BEGIN
1204:
1205: IF G_DEBUG = 'Y' THEN

Line 1213: -- Update ahl_temp_unit_effectivities with the unit effectivity id.

1209:
1210: -- For top node.
1211: Create_Record (p_x_temp_grp_rec);
1212:
1213: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1214: UPDATE ahl_temp_unit_effectivities
1215: SET unit_effectivity_id = p_x_temp_grp_rec.unit_effectivity_id
1216: WHERE csi_item_instance_id = p_x_temp_grp_rec.csi_item_instance_id AND
1217: mr_header_id = p_x_temp_grp_rec.mr_header_id AND

Line 1214: UPDATE ahl_temp_unit_effectivities

1210: -- For top node.
1211: Create_Record (p_x_temp_grp_rec);
1212:
1213: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1214: UPDATE ahl_temp_unit_effectivities
1215: SET unit_effectivity_id = p_x_temp_grp_rec.unit_effectivity_id
1216: WHERE csi_item_instance_id = p_x_temp_grp_rec.csi_item_instance_id AND
1217: mr_header_id = p_x_temp_grp_rec.mr_header_id AND
1218: forecast_sequence = p_x_temp_grp_rec.forecast_sequence;

Line 1245: -- Update ahl_temp_unit_effectivities with the unit effectivity id.

1241:
1242: -- Insert into ahl_unit_effectivities.
1243: Create_Record (l_temp_child_rec);
1244:
1245: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1246: UPDATE ahl_temp_unit_effectivities
1247: SET unit_effectivity_id = l_temp_child_rec.unit_effectivity_id
1248: WHERE CURRENT OF ahl_temp_grp_csr;
1249:

Line 1246: UPDATE ahl_temp_unit_effectivities

1242: -- Insert into ahl_unit_effectivities.
1243: Create_Record (l_temp_child_rec);
1244:
1245: -- Update ahl_temp_unit_effectivities with the unit effectivity id.
1246: UPDATE ahl_temp_unit_effectivities
1247: SET unit_effectivity_id = l_temp_child_rec.unit_effectivity_id
1248: WHERE CURRENT OF ahl_temp_grp_csr;
1249:
1250: --dbms_output.put_line ('generated unit effectivity id' || l_unit_effectivity_id);

Line 1332: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,

1328:
1329: --------------------------------------------------------------------------------
1330: -- To update decendent records and update relationships if the MR is a group MR.
1331:
1332: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1333: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1334: IS
1335:
1336: -- Read group elements.

Line 1348: FROM ahl_temp_unit_effectivities

1344: parent_mr_header_id,
1345: orig_csi_item_instance_id,
1346: orig_mr_header_id,
1347: forecast_sequence
1348: FROM ahl_temp_unit_effectivities
1349: WHERE level = p_level
1350: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
1351: AND parent_mr_header_id = p_mr_header_id
1352: AND orig_csi_item_instance_id = p_csi_item_instance_id

Line 1474: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE := p_temp_mr_rec;

1470:
1471: i NUMBER;
1472: l_grp_match_flag BOOLEAN;
1473:
1474: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE := p_temp_mr_rec;
1475: l_unit_effectivity_rec ahl_unit_effectivities_app_v%ROWTYPE;
1476:
1477: -- added for bug# 7586838
1478: CURSOR unit_deferral_csr(p_ue_id IN NUMBER) IS