APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 604: FROM AHL_MR_EFFECTIVITIES_V

600: attribute12,
601: attribute13,
602: attribute14,
603: attribute15
604: FROM AHL_MR_EFFECTIVITIES_V
605: WHERE mr_effectivity_id = c_mr_effectivity_id;
606:
607: BEGIN
608:

Line 609: -- Get the old record from AHL_MR_EFFECTIVITIES.

605: WHERE mr_effectivity_id = c_mr_effectivity_id;
606:
607: BEGIN
608:
609: -- Get the old record from AHL_MR_EFFECTIVITIES.
610: OPEN get_old_rec( p_x_effectivity_rec.mr_effectivity_id );
611:
612: FETCH get_old_rec INTO
613: l_old_effectivity_rec.name,

Line 891: AHL_MR_EFFECTIVITIES_APP_V EF

887: CURSOR get_eff_dtls_rec ( c_mr_effectivity_id NUMBER )
888: IS
889: SELECT DISTINCT EFD.manufacturer_id
890: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,
891: AHL_MR_EFFECTIVITIES_APP_V EF
892: WHERE EFD.manufacturer_id IS NOT NULL
893: AND EFD.mr_effectivity_id = EF.mr_effectivity_id
894: AND EF.mr_effectivity_id = c_mr_effectivity_id;
895:

Line 900: AHL_MR_EFFECTIVITIES_APP_V EF

896: CURSOR get_intervals_rec ( c_mr_effectivity_id NUMBER )
897: IS
898: SELECT DISTINCT INT.counter_id
899: FROM AHL_MR_INTERVALS_APP_V INT,
900: AHL_MR_EFFECTIVITIES_APP_V EF
901: WHERE INT.mr_effectivity_id = EF.mr_effectivity_id
902: AND EF.mr_effectivity_id = c_mr_effectivity_id;
903:
904: -- Tamal [MEL/CDL RM-FMP Enhancements] Begins here...

Line 1157: FROM AHL_MR_EFFECTIVITIES_APP_V

1153:
1154: CURSOR get_dup_name ( c_mr_header_id NUMBER )
1155: IS
1156: SELECT name
1157: FROM AHL_MR_EFFECTIVITIES_APP_V
1158: WHERE mr_header_id = c_mr_header_id
1159: GROUP BY name
1160: HAVING count(*) > 1;
1161:

Line 1165: FROM AHL_MR_EFFECTIVITIES_APP_V

1161:
1162: CURSOR get_dup_item ( c_mr_header_id NUMBER )
1163: IS
1164: SELECT inventory_item_id
1165: FROM AHL_MR_EFFECTIVITIES_APP_V
1166: WHERE mr_header_id = c_mr_header_id
1167: GROUP BY inventory_item_id
1168: HAVING count(*) > 1;
1169:

Line 1177: from ahl_mr_effectivities_v

1173: by Michael Payne. */
1174:
1175: cursor get_item_number (c_inventory_item_id number) is
1176: select item_number
1177: from ahl_mr_effectivities_v
1178: where inventory_item_id = c_inventory_item_id;
1179:
1180: BEGIN
1181:

Line 1461: INSERT INTO AHL_MR_EFFECTIVITIES

1457: IF ( p_x_effectivity_tbl(i).dml_operation = 'C' ) THEN
1458:
1459: BEGIN
1460: -- Insert the record
1461: INSERT INTO AHL_MR_EFFECTIVITIES
1462: (
1463: MR_EFFECTIVITY_ID,
1464: OBJECT_VERSION_NUMBER,
1465: MR_HEADER_ID,

Line 1493: AHL_MR_EFFECTIVITIES_S.NEXTVAL,

1489: CREATED_BY,
1490: LAST_UPDATE_LOGIN
1491: ) VALUES
1492: (
1493: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
1494: p_x_effectivity_tbl(i).object_version_number,
1495: p_mr_header_id,
1496: p_x_effectivity_tbl(i).name,
1497: DECODE( p_x_effectivity_tbl(i).relationship_id, NULL,

Line 1541: UPDATE AHL_MR_EFFECTIVITIES SET

1537: ELSIF ( p_x_effectivity_tbl(i).dml_operation = 'U' ) THEN
1538:
1539: BEGIN
1540: -- Update the record
1541: UPDATE AHL_MR_EFFECTIVITIES SET
1542: object_version_number = object_version_number + 1,
1543: name = p_x_effectivity_tbl(i).name,
1544: inventory_item_id = DECODE(
1545: p_x_effectivity_tbl(i).relationship_id,

Line 1595: DELETE AHL_MR_EFFECTIVITIES

1591:
1592: ELSIF ( p_x_effectivity_tbl(i).dml_operation = 'D' ) THEN
1593:
1594: -- Delete the record
1595: DELETE AHL_MR_EFFECTIVITIES
1596: WHERE mr_effectivity_id = p_x_effectivity_tbl(i).mr_effectivity_id
1597: AND object_version_number = p_x_effectivity_tbl(i).object_version_number;
1598:
1599: -- If the record does not exist, then, abort API.