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_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 854: FROM AHL_MR_EFFECTIVITY_DTLS_V

850: attribute12,
851: attribute13,
852: attribute14,
853: attribute15
854: FROM AHL_MR_EFFECTIVITY_DTLS_V
855: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
856:
857: BEGIN
858:

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

855: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
856:
857: BEGIN
858:
859: -- Get the old record from AHL_MR_EFFECTIVITY_DTLS.
860: OPEN get_old_rec( p_x_effectivity_detail_rec.mr_effectivity_detail_id );
861:
862: FETCH get_old_rec INTO
863: l_old_effectivity_detail_rec.exclude_flag,

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

1085: WHERE MR_EFFECTIVITY_EXT_DTL_ID = c_mr_effectivity_ext_dtl_id;
1086:
1087: BEGIN
1088:
1089: -- Get the old record from AHL_MR_EFFECTIVITY_DTLS.
1090: OPEN get_old_rec( p_x_effty_ext_detail_rec.mr_effectivity_ext_dtl_id );
1091:
1092: FETCH get_old_rec INTO
1093: l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE,

Line 1547: FROM AHL_MR_EFFECTIVITY_DTLS_V

1543: manufacturer,
1544: manufacture_date_from,
1545: manufacture_date_to,
1546: country
1547: FROM AHL_MR_EFFECTIVITY_DTLS_V
1548: WHERE mr_effectivity_id = c_mr_effectivity_id
1549: GROUP BY serial_number_from,
1550: serial_number_to,
1551: manufacturer,

Line 1734: FROM AHL_MR_EFFECTIVITY_DTLS_V

1730: IS
1731: SELECT serial_number_from,
1732: serial_number_to,
1733: MR_EFFECTIVITY_DETAIL_ID
1734: FROM AHL_MR_EFFECTIVITY_DTLS_V
1735: WHERE mr_effectivity_id = c_mr_effectivity_id;
1736:
1737:
1738: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )

Line 2039: INSERT INTO AHL_MR_EFFECTIVITY_DTLS

2035: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
2036: IF ( p_x_effectivity_detail_tbl(i).dml_operation = 'C' ) THEN
2037:
2038: -- Insert the record
2039: INSERT INTO AHL_MR_EFFECTIVITY_DTLS
2040: (
2041: MR_EFFECTIVITY_DETAIL_ID,
2042: OBJECT_VERSION_NUMBER,
2043: MR_EFFECTIVITY_ID,

Line 2074: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

2070: CREATED_BY,
2071: LAST_UPDATE_LOGIN
2072: ) VALUES
2073: (
2074: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
2075: p_x_effectivity_detail_tbl(i).object_version_number,
2076: p_mr_effectivity_id,
2077: p_x_effectivity_detail_tbl(i).exclude_flag,
2078: p_x_effectivity_detail_tbl(i).serial_number_from,

Line 2113: UPDATE AHL_MR_EFFECTIVITY_DTLS SET

2109:
2110: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'U' ) THEN
2111:
2112: -- Update the record
2113: UPDATE AHL_MR_EFFECTIVITY_DTLS SET
2114: object_version_number = object_version_number + 1,
2115: exclude_flag = p_x_effectivity_detail_tbl(i).exclude_flag,
2116: serial_number_from = p_x_effectivity_detail_tbl(i).serial_number_from,
2117: serial_number_to = p_x_effectivity_detail_tbl(i).serial_number_to,

Line 2158: DELETE AHL_MR_EFFECTIVITY_DTLS

2154:
2155: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'D' ) THEN
2156:
2157: -- Delete the record
2158: DELETE AHL_MR_EFFECTIVITY_DTLS
2159: WHERE mr_effectivity_detail_id = p_x_effectivity_detail_tbl(i).mr_effectivity_detail_id
2160: AND object_version_number = p_x_effectivity_detail_tbl(i).object_version_number;
2161:
2162: -- If the record does not exist, then, abort API.