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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_TEMP_UNIT_EFFECTIVITIES

Line 275: -- To write a record into ahl_temp_unit_effectivities.

271: x_next_due_date_rec OUT NOCOPY next_due_date_rec_type,
272: x_mr_interval_found OUT NOCOPY BOOLEAN,
273: x_return_val OUT NOCOPY BOOLEAN);
274:
275: -- To write a record into ahl_temp_unit_effectivities.
276: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE);
277:
278: -- To process the decendents in case the mr is a group MR.
279: PROCEDURE Process_GroupMR (p_applicable_mrs_rec IN applicable_mrs_rec_type,

Line 276: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE);

272: x_mr_interval_found OUT NOCOPY BOOLEAN,
273: x_return_val OUT NOCOPY BOOLEAN);
274:
275: -- To write a record into ahl_temp_unit_effectivities.
276: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE);
277:
278: -- To process the decendents in case the mr is a group MR.
279: PROCEDURE Process_GroupMR (p_applicable_mrs_rec IN applicable_mrs_rec_type,
280: p_new_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE,

Line 280: p_new_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE,

276: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE);
277:
278: -- To process the decendents in case the mr is a group MR.
279: PROCEDURE Process_GroupMR (p_applicable_mrs_rec IN applicable_mrs_rec_type,
280: p_new_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE,
281: p_unit_effectivity_tbl IN unit_effectivity_tbl_type,
282: p_old_UE_forecast_sequence IN NUMBER := -1);
283:
284: -- To process the dependent MRs based on the value of preceding MR.

Line 604: DELETE FROM AHL_TEMP_UNIT_EFFECTIVITIES;

600: END IF;
601:
602: -- Initialize temporary tables.
603:
604: DELETE FROM AHL_TEMP_UNIT_EFFECTIVITIES;
605: DELETE FROM AHL_TEMP_UNIT_SR_DEFERRALS;
606:
607: -- validate item instance.
608: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,

Line 2741: -- Get group MRs if any, from ahl_temp_unit_effectivities for the item instance.

2737: WHERE PARENT_UE.UNIT_EFFECTIVITY_ID = RELN.ORIGINATOR_UE_ID
2738: AND PARENT_UE.STATUS_CODE = 'INIT-ACCOMPLISHED')
2739: ORDER BY forecast_sequence ASC;
2740:
2741: -- Get group MRs if any, from ahl_temp_unit_effectivities for the item instance.
2742: -- select only the first row.
2743: CURSOR ahl_temp_ue_csr (p_item_instance_id IN NUMBER,
2744: p_mr_header_id IN NUMBER,
2745: p_last_due_date IN DATE,

Line 2754: FROM ahl_temp_unit_effectivities

2750: orig_csi_item_instance_id,
2751: orig_mr_header_id,
2752: --orig_forecast_sequence,
2753: visit_end_date
2754: FROM ahl_temp_unit_effectivities
2755: WHERE csi_item_instance_id = p_item_instance_id AND
2756: mr_header_id = p_mr_header_id AND
2757: orig_csi_item_instance_id IS NOT NULL AND
2758: orig_mr_header_id IS NOT NULL AND

Line 2787: -- Get group MRs if any, from ahl_temp_unit_effectivities for the item instance.

2783: )
2784: WHERE ROWNUM < 2;
2785:
2786: -- in case of 'next-due', we need to check p_last_due_date equality condition too.
2787: -- Get group MRs if any, from ahl_temp_unit_effectivities for the item instance.
2788: -- select only the first row.
2789: CURSOR ahl_temp_ue_csr1 (p_item_instance_id IN NUMBER,
2790: p_mr_header_id IN NUMBER,
2791: p_last_due_date IN DATE,

Line 2800: FROM ahl_temp_unit_effectivities

2796: orig_csi_item_instance_id,
2797: orig_mr_header_id,
2798: --orig_forecast_sequence,
2799: visit_end_date
2800: FROM ahl_temp_unit_effectivities
2801: WHERE csi_item_instance_id = p_item_instance_id AND
2802: mr_header_id = p_mr_header_id AND
2803: orig_csi_item_instance_id IS NOT NULL AND
2804: orig_mr_header_id IS NOT NULL AND

Line 2843: FROM ahl_temp_unit_effectivities

2839: -- Get next due date of preceding MR from temporary table.
2840: CURSOR preceding_due_date_csr (p_preceding_instance_id IN NUMBER,
2841: p_preceding_mr_header_id IN NUMBER) IS
2842: SELECT due_date
2843: FROM ahl_temp_unit_effectivities
2844: WHERE csi_item_instance_id = p_preceding_instance_id AND
2845: mr_header_id = p_preceding_mr_header_id AND
2846: preceding_check_flag = 'N'
2847: ORDER by due_date;

Line 2880: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;

2876: l_forecast_sequence NUMBER;
2877: l_old_UE_forecast_sequence NUMBER;
2878: l_next_due_date_rec next_due_date_rec_type;
2879:
2880: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
2881: l_new_unit_effectivity_initrec ahl_temp_unit_effectivities%ROWTYPE;
2882:
2883: l_temp_grp_mr_rec ahl_temp_ue_csr%ROWTYPE;
2884:

Line 2881: l_new_unit_effectivity_initrec ahl_temp_unit_effectivities%ROWTYPE;

2877: l_old_UE_forecast_sequence NUMBER;
2878: l_next_due_date_rec next_due_date_rec_type;
2879:
2880: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
2881: l_new_unit_effectivity_initrec ahl_temp_unit_effectivities%ROWTYPE;
2882:
2883: l_temp_grp_mr_rec ahl_temp_ue_csr%ROWTYPE;
2884:
2885: l_last_accomplishment_date DATE;

Line 6078: p_new_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE,

6074: ------------------------------------------------------------------------------
6075: -- To process the decendents in case the mr is a group MR.
6076:
6077: PROCEDURE Process_GroupMR (p_applicable_mrs_rec IN applicable_mrs_rec_type,
6078: p_new_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE,
6079: p_unit_effectivity_tbl IN unit_effectivity_tbl_type,
6080: p_old_UE_forecast_sequence IN NUMBER := -1)
6081:
6082: IS

Line 6160: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;

6156: mr_header_id = p_mr_header_id AND
6157: implement_status_code <> 'OPTIONAL_DO_NOT_IMPLEMENT' AND
6158: preceding_mr_header_id IS NOT NULL;
6159:
6160: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
6161: l_initialize_ue_rec ahl_temp_unit_effectivities%ROWTYPE;
6162:
6163: l_junk VARCHAR2(1);
6164: l_visit_end_date DATE;

Line 6161: l_initialize_ue_rec ahl_temp_unit_effectivities%ROWTYPE;

6157: implement_status_code <> 'OPTIONAL_DO_NOT_IMPLEMENT' AND
6158: preceding_mr_header_id IS NOT NULL;
6159:
6160: l_new_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
6161: l_initialize_ue_rec ahl_temp_unit_effectivities%ROWTYPE;
6162:
6163: l_junk VARCHAR2(1);
6164: l_visit_end_date DATE;
6165: l_unit_effectivity_id NUMBER;

Line 6550: UPDATE ahl_temp_unit_effectivities

6546: /* i.e accomplishment is based on preceding MR */
6547: IF (p_next_due_date_rec.due_date IS NULL) THEN
6548: null; /* leave all preceding_check_flag = 'Y' */
6549: ELSE
6550: UPDATE ahl_temp_unit_effectivities
6551: SET preceding_check_flag = 'N'
6552: WHERE csi_item_instance_id = p_applicable_mrs_rec.csi_item_instance_id
6553: AND mr_header_id = p_applicable_mrs_rec.mr_header_id
6554: AND due_date >= p_next_due_date_rec.due_date;

Line 6558: UPDATE ahl_temp_unit_effectivities

6554: AND due_date >= p_next_due_date_rec.due_date;
6555: END IF;
6556: ELSE
6557: /* this MR has its accomplishments; update all records irrespective of due date */
6558: UPDATE ahl_temp_unit_effectivities
6559: SET preceding_check_flag = 'N'
6560: WHERE csi_item_instance_id = p_applicable_mrs_rec.csi_item_instance_id
6561: AND mr_header_id = p_applicable_mrs_rec.mr_header_id;
6562:

Line 6573: -- To write a record into ahl_temp_unit_effectivities.

6569: END Update_check_flag;
6570:
6571:
6572: -----------------------------------------------------------
6573: -- To write a record into ahl_temp_unit_effectivities.
6574:
6575: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE)
6576:
6577: IS

Line 6575: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE)

6571:
6572: -----------------------------------------------------------
6573: -- To write a record into ahl_temp_unit_effectivities.
6574:
6575: PROCEDURE Create_temp_unit_effectivity (X_unit_effectivity_rec IN ahl_temp_unit_effectivities%ROWTYPE)
6576:
6577: IS
6578:
6579: BEGIN

Line 6585: insert into ahl_temp_unit_effectivities (

6581: AHL_DEBUG_PUB.Debug('Start Create Temporary Unit Effect');
6582: END IF;
6583:
6584: -- insert into temporary table.
6585: insert into ahl_temp_unit_effectivities (
6586: csi_item_instance_id,
6587: MR_header_id,
6588: due_date,
6589: mr_interval_id,

Line 7242: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;

7238:
7239:
7240: l_del_SQLstmt_str VARCHAR2(2000);
7241:
7242: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
7243: /* record structure to hold the activity and due date details */
7244:
7245: -- Added to fix bug# 3546136.
7246: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;

Line 7246: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;

7242: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
7243: /* record structure to hold the activity and due date details */
7244:
7245: -- Added to fix bug# 3546136.
7246: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;
7247:
7248: -- parameters needed to call get_accomplishment_details.
7249: l_last_accomplishment_date DATE;
7250: l_last_acc_counter_val_tbl counter_values_tbl_type;

Line 7529: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;

7525: l_due_at_counter_val_tbl counter_values_tbl_type;
7526:
7527: l_applicable_mrs_rec applicable_mrs_rec_type;
7528:
7529: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
7530: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;
7531:
7532: -- Added for bug# 6711228
7533: l_no_forecast_flag BOOLEAN;

Line 7530: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;

7526:
7527: l_applicable_mrs_rec applicable_mrs_rec_type;
7528:
7529: l_temp_unit_effectivity_rec ahl_temp_unit_effectivities%ROWTYPE;
7530: l_temp_ue_initrec ahl_temp_unit_effectivities%ROWTYPE;
7531:
7532: -- Added for bug# 6711228
7533: l_no_forecast_flag BOOLEAN;
7534: l_mr_accomplish_exists BOOLEAN;

Line 7992: FROM ahl_temp_unit_effectivities;

7988: -- Added service_line_id to fix FP bug# 5481605.
7989: -- read temporary table sequentially.
7990: CURSOR ahl_mr_header_csr IS
7991: SELECT DISTINCT mr_header_id, csi_item_instance_id, service_line_id
7992: FROM ahl_temp_unit_effectivities;
7993:
7994: -- retrieve current unit effectivity records.
7995: CURSOR ahl_unit_effectivity_csr (p_csi_item_instance_id IN NUMBER,
7996: p_mr_header_id IN NUMBER,

Line 8013: FROM ahl_temp_unit_effectivities

8009: CURSOR ahl_temp_effectivity_csr(p_csi_item_instance_id IN NUMBER,
8010: p_mr_header_id IN NUMBER,
8011: p_service_line_id IN NUMBER) IS
8012: SELECT unit_effectivity_id
8013: FROM ahl_temp_unit_effectivities
8014: WHERE mr_header_id = p_mr_header_id
8015: AND csi_item_instance_id = p_csi_item_instance_id
8016: AND service_line_id = p_service_line_id
8017: FOR UPDATE OF unit_effectivity_id

Line 8077: UPDATE ahl_temp_unit_effectivities

8073: l_unit_effectivity_id := l_ue_id_tbl(i);
8074:
8075: -- update record.
8076:
8077: UPDATE ahl_temp_unit_effectivities
8078: SET unit_effectivity_id = l_unit_effectivity_id
8079: WHERE CURRENT OF ahl_temp_effectivity_csr;
8080: END IF; -- ahl_temp_effectivity_csr%NOTFOUND
8081: END LOOP; -- l_ue_id_tbl.FIRST