APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_EXT_DTLS

Line 1084: FROM AHL_MR_EFFECTIVITY_EXT_DTLS

1080: attribute12,
1081: attribute13,
1082: attribute14,
1083: attribute15
1084: FROM AHL_MR_EFFECTIVITY_EXT_DTLS
1085: WHERE MR_EFFECTIVITY_EXT_DTL_ID = c_mr_effectivity_ext_dtl_id;
1086:
1087: BEGIN
1088:

Line 1562: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, ahl_owner_details_v OWN

1558: IS
1559: SELECT EFFEXT.OWNER_ID,
1560: OWN.owner_number
1561: ,EFFEXT.EFFECT_EXT_DTL_REC_TYPE
1562: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, ahl_owner_details_v OWN
1563: WHERE EFFEXT.mr_effectivity_id = c_mr_effectivity_id
1564: AND EFFEXT.OWNER_ID = OWN.owner_id
1565: AND EFFECT_EXT_DTL_REC_TYPE = 'OWNER'
1566: GROUP BY EFFEXT.OWNER_ID,

Line 1576: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, csi_lookups CS

1572: IS
1573: SELECT EFFEXT.LOCATION_TYPE_CODE,
1574: CS.meaning
1575: ,EFFEXT.EFFECT_EXT_DTL_REC_TYPE
1576: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT, csi_lookups CS
1577: WHERE EFFEXT.mr_effectivity_id = c_mr_effectivity_id
1578: and CS.lookup_type='CSI_INST_LOCATION_SOURCE_CODE' and CS.lookup_code = EFFEXT.LOCATION_TYPE_CODE
1579: AND EFFECT_EXT_DTL_REC_TYPE = 'LOCATION'
1580: GROUP BY EFFEXT.LOCATION_TYPE_CODE,

Line 1593: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT

1589: , EFFEXT.CSI_EXT_ATTRIBUTE_VALUE
1590: ,EFFEXT.EFFECT_EXT_DTL_REC_TYPE
1591: ,(Select CIEA.ATTRIBUTE_NAME from CSI_I_EXTENDED_ATTRIBS CIEA
1592: WHERE CIEA.ATTRIBUTE_CODE = EFFEXT.CSI_EXT_ATTRIBUTE_CODE AND rownum < 2) CSI_EXT_ATTRIBUTE_NAME
1593: FROM AHL_MR_EFFECTIVITY_EXT_DTLS EFFEXT
1594: WHERE EFFEXT.mr_effectivity_id = c_mr_effectivity_id
1595: AND EFFEXT.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR'
1596: GROUP BY EFFEXT.CSI_EXT_ATTRIBUTE_CODE,
1597: EFFEXT.CSI_EXT_ATTRIBUTE_VALUE,

Line 2247: INSERT INTO AHL_MR_EFFECTIVITY_EXT_DTLS

2243: FOR i IN 1..p_x_effty_ext_detail_tbl.count LOOP
2244: IF ( p_x_effty_ext_detail_tbl(i).dml_operation = 'C' ) THEN
2245:
2246: -- Insert the record
2247: INSERT INTO AHL_MR_EFFECTIVITY_EXT_DTLS
2248: (
2249: MR_EFFECTIVITY_EXT_DTL_ID,
2250: OBJECT_VERSION_NUMBER,
2251: MR_EFFECTIVITY_ID,

Line 2281: AHL_MR_EFFECTIVITY_EXT_DTLS_S.NEXTVAL,

2277: CREATED_BY,
2278: LAST_UPDATE_LOGIN
2279: ) VALUES
2280: (
2281: AHL_MR_EFFECTIVITY_EXT_DTLS_S.NEXTVAL,
2282: p_x_effty_ext_detail_tbl(i).object_version_number,
2283: p_mr_effectivity_id,
2284: p_x_effty_ext_detail_tbl(i).exclude_flag,
2285: p_x_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE,

Line 2319: UPDATE AHL_MR_EFFECTIVITY_EXT_DTLS SET

2315:
2316: ELSIF ( p_x_effty_ext_detail_tbl(i).dml_operation = 'U' ) THEN
2317:
2318: -- Update the record
2319: UPDATE AHL_MR_EFFECTIVITY_EXT_DTLS SET
2320: object_version_number = object_version_number + 1,
2321: exclude_flag = p_x_effty_ext_detail_tbl(i).exclude_flag,
2322: EFFECT_EXT_DTL_REC_TYPE = p_x_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE,
2323: OWNER_ID = p_x_effty_ext_detail_tbl(i).OWNER_ID,

Line 2363: DELETE AHL_MR_EFFECTIVITY_EXT_DTLS

2359:
2360: ELSIF ( p_x_effty_ext_detail_tbl(i).dml_operation = 'D' ) THEN
2361:
2362: -- Delete the record
2363: DELETE AHL_MR_EFFECTIVITY_EXT_DTLS
2364: WHERE MR_EFFECTIVITY_EXT_DTL_ID = p_x_effty_ext_detail_tbl(i).MR_EFFECTIVITY_EXT_DTL_ID
2365: AND object_version_number = p_x_effty_ext_detail_tbl(i).object_version_number;
2366:
2367: -- If the record does not exist, then, abort API.