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_PRD_DF_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 623: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;

619: END IF;
620:
621: IF(p_x_df_header_rec.operation_flag = G_OP_DELETE) THEN
622: -- delete schedules records
623: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
624: -- delete header records.
625: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id);
626: ELSIF(p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
627: --setting object version number for create

Line 692: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;

688: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG)THEN
689: p_x_df_header_rec.set_due_date := null;
690: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;
691: -- Delete all records in unit thresholds
692: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
693: END IF;
694: p_x_df_header_rec.approval_status_code := 'DRAFT';
695: AHL_UNIT_DEFERRALS_PKG.update_row(
696: x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id,

Line 1972: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_df_schedules_tbl(i).unit_threshold_id);

1968:
1969:
1970: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP
1971: IF(p_x_df_schedules_tbl(i).operation_flag = G_OP_DELETE) THEN
1972: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_df_schedules_tbl(i).unit_threshold_id);
1973: END IF;
1974: END LOOP;
1975:
1976: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP

Line 1985: AHL_UNIT_THRESHOLDS_PKG.update_row(

1981: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
1982: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
1983: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
1984:
1985: AHL_UNIT_THRESHOLDS_PKG.update_row(
1986: p_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
1987: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
1988: p_last_updated_by => p_x_df_schedules_tbl(i).last_updated_by,
1989: p_last_update_date => p_x_df_schedules_tbl(i).last_update_date,

Line 2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(

2021: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2022: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2023: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2024:
2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(
2026: p_x_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2027: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
2028: p_created_by => p_x_df_schedules_tbl(i).created_by,
2029: p_creation_date => p_x_df_schedules_tbl(i).creation_date,

Line 2162: SELECT 'x' FROM ahl_unit_thresholds

2158: AND CO.counter_name = MR.counter_name; */
2159:
2160:
2161: CURSOR valid_df_rec_del_csr(p_unit_threshold_id IN NUMBER, p_object_version_number IN NUMBER) IS
2162: SELECT 'x' FROM ahl_unit_thresholds
2163: WHERE object_version_number = p_object_version_number
2164: AND unit_threshold_id = p_unit_threshold_id;
2165:
2166: l_exists VARCHAR2(1);

Line 2253: FROM ahl_unit_thresholds

2249: CURSOR df_schedules_csr(p_unit_threshold_id IN NUMBER, p_object_version_number IN NUMBER) IS
2250: SELECT unit_deferral_id,counter_id,counter_value,ctr_value_type_code,attribute_category, attribute1,attribute2, attribute3, attribute4,
2251: attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
2252: attribute12, attribute13, attribute14, attribute15
2253: FROM ahl_unit_thresholds
2254: WHERE object_version_number= p_object_version_number
2255: AND unit_threshold_id = p_unit_threshold_id;
2256:
2257: l_df_schedules_rec AHL_PRD_DF_PVT.df_schedules_rec_type;

Line 2615: FROM CS_COUNTERS CO,ahl_unit_thresholds UT

2611: l_count2 NUMBER;
2612:
2613: CURSOR counter_values_csr(p_unit_deferral_id IN NUMBER) IS
2614: SELECT UT.counter_id, CO.name, UT.counter_value, UT.ctr_value_type_code,CO.uom_code
2615: FROM CS_COUNTERS CO,ahl_unit_thresholds UT
2616: WHERE CO.counter_id = UT.counter_id
2617: AND UT.unit_deferral_id = p_unit_deferral_id;
2618:
2619: l_counter_id NUMBER;

Line 2683: SELECT count(*) INTO l_count1 from (SELECT counter_id FROM ahl_unit_thresholds

2679: );
2680: END IF;
2681:
2682: -- df schedule validity for the the unit_deferral_id.
2683: SELECT count(*) INTO l_count1 from (SELECT counter_id FROM ahl_unit_thresholds
2684: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);
2685:
2686: SELECT count(*) INTO l_count2 from (SELECT DISTINCT counter_id FROM ahl_unit_thresholds
2687: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);

Line 2686: SELECT count(*) INTO l_count2 from (SELECT DISTINCT counter_id FROM ahl_unit_thresholds

2682: -- df schedule validity for the the unit_deferral_id.
2683: SELECT count(*) INTO l_count1 from (SELECT counter_id FROM ahl_unit_thresholds
2684: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);
2685:
2686: SELECT count(*) INTO l_count2 from (SELECT DISTINCT counter_id FROM ahl_unit_thresholds
2687: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);
2688: IF(l_count1 <> l_count2) THEN
2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_CNT_NAME_REP');
2690: FND_MSG_PUB.ADD;

Line 4854: SELECT unit_threshold_id FROM ahl_unit_thresholds

4850: WHERE defer_from_ue_id = UD.unit_effectivity_id
4851: );
4852:
4853: CURSOR redundant_threshold_csr(p_unit_deferral_id IN NUMBER) IS
4854: SELECT unit_threshold_id FROM ahl_unit_thresholds
4855: WHERE unit_deferral_id = p_unit_deferral_id;
4856:
4857:
4858: BEGIN

Line 4967: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);

4963: END IF;
4964:
4965: FOR redundant_deferral_rec IN redundant_deferral_ue_csr(p_unit_effectivity_id) LOOP
4966: FOR redundant_threshold_rec IN redundant_threshold_csr(redundant_deferral_rec.unit_deferral_id) LOOP
4967: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
4968: END LOOP;
4969: AHL_UNIT_DEFERRALS_PKG.delete_row(redundant_deferral_rec.unit_deferral_id);
4970: END LOOP;
4971:

Line 5101: FROM MTL_UNITS_OF_MEASURE_VL MU, CS_COUNTERS CO,ahl_unit_thresholds UT

5097: -- fetch deferral schedule rec
5098: CURSOR df_schedule_tbl_csr(p_unit_deferral_id IN NUMBER) IS
5099: SELECT UT.unit_threshold_id,UT.object_version_number,UT.unit_deferral_id, UT.counter_id,
5100: CO.name, UT.counter_value, UT.ctr_value_type_code,MU.unit_of_measure
5101: FROM MTL_UNITS_OF_MEASURE_VL MU, CS_COUNTERS CO,ahl_unit_thresholds UT
5102: WHERE MU.uom_code = CO.uom_code
5103: AND CO.counter_id = UT.counter_id
5104: AND UT.unit_deferral_id = p_unit_deferral_id
5105: ORDER BY CO.name;

Line 5420: SELECT unit_threshold_id FROM ahl_unit_thresholds

5416:
5417: l_unit_deferral_id NUMBER;
5418:
5419: CURSOR redundant_threshold_csr(p_unit_deferral_id IN NUMBER) IS
5420: SELECT unit_threshold_id FROM ahl_unit_thresholds
5421: WHERE unit_deferral_id = p_unit_deferral_id;
5422:
5423: BEGIN
5424: OPEN unit_deferral_csr(p_unit_effectivity_id);

Line 5430: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);

5426: IF(unit_deferral_csr%NOTFOUND)THEN
5427: RETURN FALSE;
5428: ELSE
5429: FOR redundant_threshold_rec IN redundant_threshold_csr(l_unit_deferral_id) LOOP
5430: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
5431: END LOOP;
5432: AHL_UNIT_DEFERRALS_PKG.delete_row(l_unit_deferral_id);
5433: END IF;
5434: RETURN TRUE;