APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 481: FROM AHL_MR_EFFECTIVITY_DTLS_V

477: attribute12,
478: attribute13,
479: attribute14,
480: attribute15
481: FROM AHL_MR_EFFECTIVITY_DTLS_V
482: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
483:
484: BEGIN
485:

Line 486: -- Get the old record from AHL_MR_EFFECTIVITY_DTLS.

482: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
483:
484: BEGIN
485:
486: -- Get the old record from AHL_MR_EFFECTIVITY_DTLS.
487: OPEN get_old_rec( p_x_effectivity_detail_rec.mr_effectivity_detail_id );
488:
489: FETCH get_old_rec INTO
490: l_old_effectivity_detail_rec.exclude_flag,

Line 825: FROM AHL_MR_EFFECTIVITY_DTLS_V

821: manufacturer,
822: manufacture_date_from,
823: manufacture_date_to,
824: country
825: FROM AHL_MR_EFFECTIVITY_DTLS_V
826: WHERE mr_effectivity_id = c_mr_effectivity_id
827: GROUP BY serial_number_from,
828: serial_number_to,
829: manufacturer,

Line 890: FROM AHL_MR_EFFECTIVITY_DTLS_V

886: IS
887: SELECT serial_number_from,
888: serial_number_to,
889: MR_EFFECTIVITY_DETAIL_ID
890: FROM AHL_MR_EFFECTIVITY_DTLS_V
891: WHERE mr_effectivity_id = c_mr_effectivity_id;
892:
893:
894: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )

Line 1108: INSERT INTO AHL_MR_EFFECTIVITY_DTLS

1104: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1105: IF ( p_x_effectivity_detail_tbl(i).dml_operation = 'C' ) THEN
1106:
1107: -- Insert the record
1108: INSERT INTO AHL_MR_EFFECTIVITY_DTLS
1109: (
1110: MR_EFFECTIVITY_DETAIL_ID,
1111: OBJECT_VERSION_NUMBER,
1112: MR_EFFECTIVITY_ID,

Line 1143: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

1139: CREATED_BY,
1140: LAST_UPDATE_LOGIN
1141: ) VALUES
1142: (
1143: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
1144: p_x_effectivity_detail_tbl(i).object_version_number,
1145: p_mr_effectivity_id,
1146: p_x_effectivity_detail_tbl(i).exclude_flag,
1147: p_x_effectivity_detail_tbl(i).serial_number_from,

Line 1182: UPDATE AHL_MR_EFFECTIVITY_DTLS SET

1178:
1179: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'U' ) THEN
1180:
1181: -- Update the record
1182: UPDATE AHL_MR_EFFECTIVITY_DTLS SET
1183: object_version_number = object_version_number + 1,
1184: exclude_flag = p_x_effectivity_detail_tbl(i).exclude_flag,
1185: serial_number_from = p_x_effectivity_detail_tbl(i).serial_number_from,
1186: serial_number_to = p_x_effectivity_detail_tbl(i).serial_number_to,

Line 1227: DELETE AHL_MR_EFFECTIVITY_DTLS

1223:
1224: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'D' ) THEN
1225:
1226: -- Delete the record
1227: DELETE AHL_MR_EFFECTIVITY_DTLS
1228: WHERE mr_effectivity_detail_id = p_x_effectivity_detail_tbl(i).mr_effectivity_detail_id
1229: AND object_version_number = p_x_effectivity_detail_tbl(i).object_version_number;
1230:
1231: -- If the record does not exist, then, abort API.