1282: IS
1283: CURSOR c_get_custom_api IS
1284:
1285: SELECT DESCRIPTION
1286: FROM FND_LOOKUPS
1287: WHERE LOOKUP_CODE = 'CUSTOM_SUSTAIN_ASPECT_API' AND
1288: LOOKUP_TYPE ='MTH_CUSTOM_PLSQL_API';
1289:
1290: v_api_name VARCHAR2(200) := NULL;
1307:
1308:
1309: BEGIN
1310: SELECT DESCRIPTION INTO v_api_name
1311: FROM FND_LOOKUPS
1312: WHERE LOOKUP_CODE = 'CUSTOM_SUSTAIN_ASPECT_API' AND
1313: LOOKUP_TYPE ='MTH_CUSTOM_PLSQL_API';
1314:
1315: IF (sql%NOTFOUND) THEN